Microsoft Office Tutorials and References
In Depth Information
Formatting Table Elements
Formatting Table Elements
When you create a table in a worksheet, Excel displays a standard set of elements, includ-
ing headings, columns, and rows. You can select options on the Design tab under Table
Tools to quickly format a table. These options allow you to format the header row, and
first and last column as special. You can also format even columns or rows differently than
odd columns or rows. If you want to total numbers in a column, you can format the bottom
row of a table for column totals. If you want to customize a list to certain items, you can
set AutoFilters, which you access using a Filter button ( New ! ) (drop-down list arrow). If
you no longer want these formatting elements, you can hide them. If you hide the header
row, the table header AutoFilters and any applied filters are removed from the table.
Show or Hide Table Formatting Elements
Select a cell or range in the table you want to modify.
Click the Design tab under Table Tools.
Select or clear the check box for the element you want to show or hide:
Header Row to format the top row of the table as special.
Total Row to format the bottom row of the table for column totals.
First Column to format the first column of the table as special.
Last Column to format the last column of the table as special.
Banded Columns to format even columns differently than odd columns.
Banded Rows to format even rows differently than odd rows.
Filter Button ( New ! ) (drop-down list arrow) to filter elements in a list.
Search JabSto ::




Custom Search