All Excel tables are composed of rows and columns, and share a number of common elements.
First, there’s the table itself, which is a rectangular range of cells with a unique name.
You’ll see the table name on the design tab, and in the name box menu.
The data range in a table is dynamic.
As rows are added or removed, Excel will keep track of these changes.
The header row displays column names.
The header row is actually optional, but most tables will have one.
The data in a table includes all rows defined in the table range.
When you use the name box to select a table, only the data is selected.
The total row is the last row in a table, and is meant to hold summary calculations.
All new tables include a filter displayed in the header row.
Each button in the filter contains a menu of options relevant to the data in that column.
Some tables have calculated columns.
For example, the Total and Tax columns in this table are calculated columns.
By default, formulas that refer to tables will use structured references.
Tables can be automatically formatted with Table Styles.
Styles apply uniform formatting to an entire table in one click.
Finally, you’ll also find a sizing handle in the lower right corner of all tables.
This control lets you manually resize a table.
