Format a range as a table

Updated November 13, 2026

A table keeps a range together: new rows take its formatting and formulas, and every column gets a filter button.

Make a table

  1. Click anywhere in your data.
  2. Choose Home › As table or Insert › Table (Ctrl+T), and pick a style.
  3. Check the range and whether it has headers, then choose OK.

Change the table

Click in the table to show Table Design:

  • Table name: use the name in formulas, such as =SUM(Sales[Amount]).
  • Resize Table: change the range it covers.
  • Header Row, Total Row, Banded Rows and Filter Button: turn each on or off. The total row picks a sum, average, count and more for each column.
  • Table styles: pick another look.
  • Convert to Range: turn it back into ordinary cells, keeping the formatting.

Was this article helpful?