I’m hoping this capability is not unique to Excel… This question has been asked about Google Sheets also with negative results:
In Excel you are able to take a range of cells and convert it to a Table which has the following benefits:
- Banded row
- Filterable columns
- Functions in columns are automatically applied as new rows of data are entered
- Range becomes a dynamic named range that grows as new rows/columns are added
- PivotTables that reference this source table’s columns automatically adjust as new rows are added
- Aggregating functions like Sum() & Average() automatically adjust to the number of rows.
Is there a way to turn a selected range into a dynamic Table?