Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.1. Apply and modify cell formats: Format Table Style Options

 

Table Style Options

You can use the Table Style Options to display the Header Row, Total Row and formatting if you wish.

 

5. Try It: Add or Remove the Header
Go to Table Tools-> Design.

Look in the Table Style Options.

Uncheck the Header Row.

 

What Do You See? When you turn off the Header Row, the first row becomes blank. The Filter on Sales Rep is gone, too, so you should see all of the data.

 

Trust But Verify: Turn the Header Row back on, please. The Header and the Filters should be available again.

 

Memo to Self: The Header Row Field Names are saved in the Table Properties.

 

Table Tools->Design ->Table Style Options