Pressing Ctrl+T inside a list turns it into an Excel Table. It looks like a formatting trick, but it changes how the whole workbook behaves. Here is why I convert almost every list.

1. Formulas fill down automatically

Type a formula in the first row of a new column and Excel copies it to every row — and to new rows added later.

2. Readable structured references

=[@Qty]*[@Price]            ' inside the table
=SUM(Sales[Amount])          ' anywhere in the workbook

Instead of =F2*G2 you read quantity times price. References follow the column even if it moves.

3. Ranges grow by themselves

Pivot tables, charts, data validation and formulas that point at a table include new rows automatically — no more “last row” maintenance.

4. A totals row in one click

Table Design → Total Row. Each total cell has a dropdown (Sum, Average, Count…) and uses SUBTOTAL, so it respects filters.

5. Filters and sorting built in

Every header has a filter button, and the header row stays visible while scrolling instead of the column letters.

6. Slicers

Table Design → Insert Slicer adds clickable filter buttons — great for dashboards shared with people who do not like dropdowns.

7. Banded rows without formatting work

Pick a style once; banding stays correct when you sort or add rows.

8. Better Power Query and pivot sources

Data → From Table/Range and Insert → PivotTable both work best on tables, and the connection survives new rows.

9. Named, findable data

Rename the table (Table Design → Table Name, e.g. Sales). It appears in the Name Box dropdown and in formula autocomplete.

10. Easier VBA

Dim lo As ListObject
Set lo = ActiveSheet.ListObjects("Sales")
lo.ListRows.Add.Range.Cells(1, 1).Value = "INV-0099"   ' append a row