-
Step 1
Open up the spreadsheet you want to create the macro in.
-
Step 2
Click on "Tools," "Macros," "Record new macro" and the record macro dialogue box will appear.
-
Step 3
Fill in the dialogue box with the name you want to call your macro where it says "Macro name." You can make a shortcut key, for example if you put "H" in the shortcut key box, the macro will be run every time you hold down the ctrl key and press "H". Next, put where you want to save it, which is usually the spreadsheet you are working in. Type in a description of the macro. When you have finished hit the "OK" box and the macro recording box will appear.
-
Step 4
Start your routine. For example, you can insert rows, delete rows, insert columns, add columns, etc. Whatever you normally would do to the spreadsheet just do it while the record button is on. When you have completed the work, turn the macro off. If the "Turn macro off" box is on your screen use it, if not click on "Tools," "Macros," "Turn macro off" on your tool bar.
-
Step 5
Play back the macro. You have assigned Ctrl+H to your macro, hit it now and it will go through all the steps you just did. If you need to do this several times a day or even several times a week or month you are going to save valuable time by using your macro.
-
Step 6
Save your spreadsheet and exit. The next time you open it just select ctrl+h and it will complete your routine for you.
