Launch a new session of Microsoft Excel and wait for a few moments so that the program can load completely.
Click on the Microsoft Office logo at the top left corner of the Excel screen and then click the button labelled ‘Excel Options’. From the left hand pane of the dialogue box which appears, click ‘Customise Ribbon’ and then check the option labelled ‘Developer’ on the right hand pane. Click ‘OK’ to confirm. You should now be able see the Developer tab on Excel's main screen.
Change the title of the worksheet on which you are working. You can choose any title that you deem appropriate.
Click on the tab labelled ‘Developers’ and then click the optioned labelled ‘Record Macro’ to open the Record Macro dialogue box.
You will now need to specify the macro perimeters. Name the macro, choose a shortcut key for the macro, choose where you would like the macro to be stored and add a short description of the macro you are creating in the appropriate fields.
You now need to record the steps of the macro. Click on the button labelled ‘OK’ on the Record Macro dialogue box. From this point onwards, all the actions you perform on the worksheet would be recorded until you stop the recording process.
Perform all the actions you would like the macro to repeat. Be sure to get the clicks right. When you are done, click on the tab labelled ‘Developer’ and click the button labelled ‘Stop Recording’.
Select a new worksheet from the tabs at the bottom of the Excel screen and click on the cell from which you started recording the macro. Type in the predefined title and press the ‘Enter’ key. Click the ‘Macros’ button under the ‘Developer’ tab then select ‘format_titles’ macro in the ‘Macro name’ window under the ‘View Macro’ dialogue box. Finally, click the button labelled ‘Run’ to start the macro.