Course / Tables

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:

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

  1. 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.

  2. 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.

  3. Now add an order. Type straight under the table: SO-5008 in A9, Shelf in B9, 2 in C9 and 129 in D9.

Remember

Previous: Filter by numbers, then sort what shows · Next: Formulas that read a table by name