Recording the Macro
Note: For help on these steps, refer to the image above.
- Click the OK button in the Record Macro dialog box to start the macro recorder.
- Click on the Home tab of the ribbon.
- Drag select cells A1 to F1 in the worksheet to highlight them.
- Click on the Merge and Center icon to center the title between cells A1 and F1.
- Click on the Fill Color icon (looks like a paint can) to open the fill color drop down list.
- Choose Blue, Accent 1 from the list to turn the background color of the selected cells to blue.
- Click on the Font Color icon (it is a large letter "A") to open the font color drop down list.
- Choose White from the list to turn the text in the selected cells to white.
- Click on the Font Size icon (above the paint can icon) to open the font size drop down list.
- Choose 16 from the list to change the size the text in the selected cells to 16 point.
- Click on the Developer tab of the ribbon.
- Click the Stop Recording button on the ribbon to stop the macro recording.
- At this point, your worksheet title should resemble the title in the image above.
