Home > Articles

Entering Data

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Formatting the Datasheet

1Open the Format menu and choose Datasheet.

2The Datasheet Formatting dialog box opens. Choose Flat, Raised, or Sunken in the Cell Effect area to specify how cells in the datasheet should look.

3To apply a background color to the datasheet (the default is white), click the down arrow next to the Background Color field and choose a color from the list that appears.

4To change the color of the datasheet's gridlines, click the down arrow next to the Gridline Color field and choose a color from the list that appears.

5To change the line style of the datasheet border, gridlines, or column heading underline, select the item to change from the leftmost drop-down list in the Border and Line Styles area.

6Click the down arrow next to the rightmost field in the Border and Line Styles area and select a line style for the datasheet border, gridline, or column heading underline.

7The Sample area of the Datasheet Formatting dialog box shows a preview of your changes. If you are satisfied with the datasheet's new appearance, click OK.

8The datasheet is formatted with your selections.

  • + Share This
  • 🔖 Save To Your Account