Excel provides four options for Tables you should be aware of.
The first option controls whether a table range will automatically adjust as data changes.
By default, this option is enabled, since this feature is a key benefit of tables.
For example, if I enter a new row in this table, the table expands to include it.
The same is true when I add a new column header.
In Windows, the setting that controls this behavior is in the proofing area, under Autocorrect controls.
On a Mac, the setting is in the Tables and Filters area.
Windows: Options > Proofing, Autocorrect options > Autoformat > include new rows and columns in tables.
Though I can still adjust the table range with the sizing handle.
Tables also have a setting to automatically fill formulas.
This setting will create Calculated Columns when aformulais entered in a column.
In Windows, you’ll find this setting in the Proofing area, under Autocorrect options.
On a Mac, the setting is in the Tables and Filters pane.
Windows: Options > Proofing, autocorrect tweaks > Autoformat > Fill formulas to create calculated columns.
Regardless of the setting, you’re free to use either normal cell references or structured references.
The setting only controls whether structured references are used by default.
The last setting is related to filtering dates.
To illustrate how this works, I’ll first suspend the setting.
In Windows, you’ll find this option in the advanced area, under display options for this workbook.
When I tap the Date filter, notice I see all individual dates.
I’ll re-switch on the date group setting.
Back in the table, the filter now groups all dates neatly by year and month.
