Show or Hide Table Formatting Elements : Table Format « Table « Microsoft Office Excel 2007 Tutorial






Select a cell or range in the table. 
           Click the Design tab under Table Tools.
Select a cell or range in the table. Click the Design tab under Table Tools.
Select Header Row to format the top row of the table as special.
Select Header Row to format the top row of the table as special.
Select Totals Row to format the bottom row of the table for column totals.
Select Totals Row to format the bottom row of the table for column totals.
Select First Column to format the first column of the table as special.
Select First Column to format the first column of the table as special.
Select Last Column to format the last column of the table as special.
Select Last Column to format the last column of the table as special.
Select Banded Column to format even columns differently than odd columns.
Select Banded Column to format even columns differently than odd columns.
Select Banded Rows to format even rows differently than odd rows.
Select Banded Rows to format even rows differently than odd rows.








4.3.Table Format
4.3.1.Apply a Quick Style to a TableApply a Quick Style to a Table
4.3.2.Copy cell formats with Format PainterCopy cell formats with Format Painter
4.3.3.Remove or clear a table styleRemove or clear a table style
4.3.4.Create or Modify a Table StyleCreate or Modify a Table Style
4.3.5.Delete a custom table styleDelete a custom table style
4.3.6.Show or Hide Table Formatting ElementsShow or Hide Table Formatting Elements