How to Create a Macro in Excel

Step-by-Step Guide

1. 1

   Step 1: Click on “File” and select “Options.”;

   The first character of the macro name must be a letter. ,,, The actions must be performed in the correct order for the macro to work as needed.
   
   For example, if you typically copy and paste a specific range of cells, perform these very actions when recording the macro. , Your macro has now been created. , The macro will now run.
2. 2

   Step 2: Click on “Customize Ribbon

3. 3

   Step 3: ” then place a checkmark next to “Developer.”

4. 4

   Step 4: Click “OK.” The Developer’s tab will now display at the top of Excel.

5. 5

   Step 5: Click on “Macro Security” in the Code group on the Developer tab.

6. 6

   Step 6: Click on “Enable all macros

7. 7

   Step 7: ” then select “OK.”

8. 8

   Step 8: Click on “Record Macro” on the Developer tab.

9. 9

   Step 9: Type a name for the macro in the “Macro name” box.

10. 10

    Step 10: Select the workbook in which you want the macro stored under “Store macro in.” If you want the macro to be available in any spreadsheet when using Excel

11. 11

    Step 11: select “Personal Macro Workbook.”

12. 12

    Step 12: Type a description for the macro into the “Description” box

13. 13

    Step 13: then click “OK.”

14. 14

    Step 14: Perform all the actions you want recorded in the macro.

15. 15

    Step 15: Click on “Stop Recording” on the Developer tab.

16. 16

    Step 16: Press CTRL + F8.

Detailed Guide

About the Author