One of the most useful features ofExcel Tablesis that they create a dynamic range.
To illustrate, I’ll add someformulasto this worksheet to report on the size of this table.
The first formula counts rows with theROWS function.
The second formula counts columns with theCOLUMNS function.
Both formulas use only the table name as a reference.
I’ll also add another formula to calculate a count of all cells in the table.
Now I’ll make some changes to the table.
First, I’ll add 2 new rows.
Notice the table automatically expands to include the new rows, and the row count increases.
If I delete the last two rows, the formulas show the original counts.
Now I’ll add a new column with a formula to calculate a total.
Again, notice the table expands, and the column count increases by one.
I’ll add one more formula to sum the Total column with theSUM function.
Tables create structured references.
Structured references are powerful.
Watch what happens when I paste in data from the second sheet.
Second, the table range has was automatically expanded to include the new data.
This means all results are up-to-date.
There is no need to manually adjust any of the ranges.
This is the real power of Tables.
