To complete the database formatting:
For help on these steps, refer to the image above.
- Drag select cells A1 to E1 in the spreadsheet.
- Click on the Home tab.
- Click on the Merge and Center option of the ribbon to center the title.
- Click on the Fill Color (looks like a paint can) on the ribbon to open the fill color drop down list.
- Choose Blue, Accent 1 from the list to change the color of the background in cells A1 - E1 to dark blue.
- Click on the Font Color icon on the Formatting Toolbar (it is a large letter " A ") to open the font color drop down list.
- Choose White from the list to change the color of the text in cells A1 - E1 to white.
- Drag select cells A2 - E2 on the spreadsheet.
- Click on the Fill Color on the ribbon to open the fill color drop down list.
- Choose Blue, Accent 1, Lighter 80 from the list to change the color of the background in cells A2 - E2 to light blue.
- Drag select cells A4 - E14 on the spreadsheet.
- Click on the Center option on the ribbon to center align the text in cells A14 to E14.
- 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.
Return to Index page
