Excel® 2013 On Demand

Formatting Table Elements

When you create a table in a worksheet, Excel displays a standard set of elements, including 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 ...