How to Create a Table in Excel: Format as Table, Structured References and Total Row
- Tahir Abbas
- November 18, 2026
An Excel table is a range of data that Excel treats as one object. It grows when you add rows, copies formulas down by itself, keeps the header row in view, and gives you filter buttons, banded rows and a total row with one click. Tables also make formulas easier to read, because you can

