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
- Click anywhere in your data.
- Choose Home › As table or Insert › Table (Ctrl+T), and pick a style.
- 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.