A table (Insert → Table or Home → Format as Table, Ctrl+T) is a range Excel treats as one whole:
- banded formatting and filter buttons in the headers;
- it grows by itself: type data in the row right below the table or the column to its right — the table expands, and formulas, charts and PivotTables see it;
- calculated columns: a formula typed into one cell of an empty column fills the whole column at once;
- structured references use column names instead of addresses:
Table1[Amount] | the whole Amount column (no header) — =SUM(Table1[Amount]) includes new rows too |
[@Amount] | the Amount value in the same row — =[@Amount]*1.2 |
Table1 | all data of the table: =ROWS(Table1) |
Rename a table on the Table Design tab → Table Name. Clear names (Orders, Prices) make formulas readable.