Question

write steps to record a macro?
​

Answer 1

Answer:

hru handsome girl's wife?

ur handsome girl is fine

hru?

good evening

Explanation:

Record a macro with a button

Click View > Macros > Record Macro.

Type a name for the macro.

To use this macro in any new documents you make, be sure the Store macro in box says All Documents (Normal. ...

To run your macro when you click a button, click Button.

Click the new macro (it's named something like Normal.

Answer 2

1. To record a macro in Excel, click the “View” tab in the Ribbon.
2. Then click the “Macros” drop-down button in the “Macros” button group.
3. Then select the “Record Macro…” command to open the “Record Macro” dialog box.
4. In the “Record Macro” dialog box, enter a name for your new macro into the “Macro name” text box.
5. To create a custom keyboard shortcut to use in conjunction with the “Ctrl” key, type the desired shortcut key letter into the text box next to the “Ctrl +” label. If you decide to do this, make sure you don’t overwrite an existing shortcut!
6. Select the name of the workbook to which to attach the macro from the “Store macro in:” drop-down.
7. To record your macro’s actions, click the “OK” button and then perform the actions to record.
8. To use relative cell referencing when recording a macro, click the “Macros” drop-down button in the “Macros” group.
9. Then select the “Use Relative References” command.
10. To switch back to absolute cell referencing when recording a macro, click the “Macros” drop-down button in the “Macros” group.
11. Then select the “Use Relative References” command again to turn it off.
12. To stop recording the macro, click the “View” tab in the Ribbon.
13. Then click the “Macros” drop-down button in the “Macros” button group.
14. Then select the “Stop Recording” command.