Turn a range into a table
Make a table from a block of data, give it a name, and watch it grow when a new row is typed under it. Beginner · 5 min · Table, Ctrl+T, Table name, A table grows
A block of data with headings is just cells until you tell Excel it is a table. Then Excel knows where it starts and ends, and several things come with that:
- The headings get filter buttons, and every other row is shaded so long rows are easy to follow.
- The table has a name, and formulas can read its columns by their headings.
- When a row is typed straight under it, the table grows to take it in, and so does every formula, chart and PivotTable that reads the table.
In Excel: click any cell of the data and press Ctrl+T (or Insert, Table), check the range and press Enter. The name is on the Table Design tab.
The Table button is in the toolbar above the grid. Click a cell of the data first, then the button: a panel opens beside the sheet.
Steps
Click any cell of the orders, then click Table in the toolbar. The panel suggests the whole block,
A1:D8, with its first row as the headings. Click Create table.A new table is called Table1, which says nothing. With a cell of the table selected, type Orders under Name in the Table panel and press Enter.
Now add an order. Type straight under the table:
SO-5008inA9,ShelfinB9,2inC9and129inD9.
Remember
- Ctrl+T (here, the Table button) turns a block of data with headings into a table.
- Give it a name without spaces.
- Type straight under a table and it grows to take the row in.
- Convert to a range in the panel turns it back into ordinary cells.
Previous: Filter by numbers, then sort what shows · Next: Formulas that read a table by name