1. Computing

Excel 2003 Database Tutorial

By

9 of 9

Completing the Database Formatting
Completing the Database Formatting

Completing the Database Formatting

© Ted French

Formatting the Database:

Note: This step involves using icons located on the Formatting toolbar, which is normally located at the top of the Excel 2003 screen. If it is not present, this article, Finding Excel Toolbars can help you locate it.

  1. Highlight cells A1 to E1 in the worksheet.

  2. Click on the Merge and Center icon on the Formatting Toolbar to center the title.

  3. With cells A1 to E1 still selected, click on the Fill Color icon on the Formatting Toolbar (looks like a paint can) to open the background color drop down list.

  4. Choose Sea Green from the list to change the background color of cells A1 - E1 to dark green.

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

  6. Choose White from the list to change the color of the text in cells A1 - E1 to white.

  7. Highlight cells A2 - E2 in the worksheet.

  8. Click on the Fill Color icon on the Formatting Toolbar to open the background color drop down list.

  9. Choose Light Green from the list to change the background color of cells A2 - E2 to light green.

  10. Highlight cells A3 - E14 on the worksheet.

  11. Choose Format > AutoFormat from the menus to open the AutoFormat dialog box.

  12. Choose List 2 from the list of options to format cells A3 - E14.

  13. Highlight cells A3 - E14 on the worksheet.

  14. Click on the Center option icon on the Formatting Toolbar to center align the text in cells A3 to E14.

  15. At this point, if you have followed all the steps of this tutorial correctly, your spreadsheet should resemble the spreadsheet pictured in Step 1 of this tutorial.

©2014 About.com. All rights reserved.