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. You may also see an error message that warns that turning off the Header Row will change the answer in the Total Row. Yes, it will. The Filter and the Filter button on Sales Rep will be removed when you turn off the Header Row so you should see all four Sales Reps shown in the Total.   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. Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.2 Modify a Table: Apply Table Style Options (Header Row)

Table Tools->Design ->Table Style Options