How to Make a Table in Excel (and Why You Should)

What an Excel Table actually is

An Excel Table (capital T) is a special structured range that Excel treats differently from a plain block of data. It has a name, automatic formatting, built-in filters, and — most importantly — it expands automatically when you add new rows or columns.

Most beginners never use Tables. Most experienced users use them for almost everything.

How to create a Table

Click anywhere inside your data

You don't need to select the whole range — just click one cell inside the data.

Press Ctrl + T

Or go to Insert → Table. Excel detects your data range automatically.

Confirm the range and click OK

Check "My table has headers" if your first row contains column names. Click OK.

What changes when you create a Table

Automatic filter dropdowns appear on every header — click to filter or sort any column instantly
Banded rows apply automatically for readability
Formulas expand automatically — write a formula in one cell and it fills the whole column
The Table grows automatically — add a row below the last row and it joins the Table
Charts and pivot tables built from Tables update automatically when new data is added

Structured references — the superpower

Inside a Table, you can reference columns by name instead of cell addresses. If your Table is called Table1 and has a column called Sales:

=SUM(Table1[Sales])
-- Always sums the entire Sales column, even as new rows are added
-- Compare to =SUM(B2:B100) which misses any rows added after B100

💡 Name your Table something meaningful

Click anywhere in the Table → Table Design tab → change "Table1" to "SalesData" or "Employees". Your formulas become self-documenting: =SUM(SalesData[Revenue]) tells you exactly what it does.

When not to use a Table

Tables don't work well when you need to merge cells, when you're working with summary rows that shouldn't expand, or when you're building a layout-heavy report. For raw data storage and analysis, always use Tables. For formatted reports and dashboards, plain ranges are sometimes more flexible.

Practice what you just learned

ExcelPro has 880+ hands-on exercises across 9 tracks — type real formulas, get instant feedback.

Start practising free →

How to make a tablein Excel