1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Macro Tutorial

By , About.com Guide

5 of 7

Adding the Macro Steps

Excel 2007 Macro Recorder Tutorial

Excel 2007 Macro Recorder Tutorial

� Ted French

Recording the Macro

Note: For help on these steps, refer to the image above.

  1. Click the OK button in the Record Macro dialog box to start the macro recorder.

  2. Click on the Home tab of the ribbon.

  3. Drag select cells A1 to F1 in the worksheet to highlight them.

  4. Click on the Merge and Center icon to center the title between cells A1 and F1.

  5. Click on the Fill Color icon (looks like a paint can) to open the fill color drop down list.

  6. Choose Blue, Accent 1 from the list to turn the background color of the selected cells to blue.

  7. Click on the Font Color icon (it is a large letter "A") to open the font color drop down list.

  8. Choose White from the list to turn the text in the selected cells to white.

  9. Click on the Font Size icon (above the paint can icon) to open the font size drop down list.

  10. Choose 16 from the list to change the size the text in the selected cells to 16 point.

  11. Click on the Developer tab of the ribbon.

  12. Click the Stop Recording button on the ribbon to stop the macro recording.

  13. At this point, your worksheet title should resemble the title in the image above.

< Previous | Next >

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Advanced Excel
  5. Excel 2007 Macro Recorder - Excel 2007 Macro Recorder Tutorial - Excel 2007 Macro Tutorial

©2009 About.com, a part of The New York Times Company.

All rights reserved.