Create and format tables
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016Create and format a table to visually group and analyze data.
Note: Excel tables shouldn't be confused with the data tables that are part of a suite of What-If Analysis commands (Forecast, on the Data tab). See Introduction to What-If Analysis for more information.
-
Select a cell within your data.
-
Select Home > Format as Table.
-
Choose a style for your table.
-
In the Create Table dialog box, set your cell range.
-
Mark if your table has headers.
-
Select OK.
-
Select the cell or the range in the data.
-
In the Home menu, select Format as Table.
-
Choose a style for your table.
-
In the Format as Table dialog box, set your cell range.
-
Mark if your table has headers.
-
Select OK.
See Overview of Excel tables for more information.
To add a blank table, select the cells you want included in the table and click Insert > Table.
To format existing data as a table by using the default table style, do this:
-
Select the cells containing the data.
-
Click Home > Table > Format as Table.
-
If you don’t check the My table has headers box, Excel for the web adds headers with default names like Column1 and Column2 above the data. To rename a default header, double-click it and type a new name.
Note: You can’t change the default table formatting in Excel for the web.
Want more?
Video: Create and format an Excel table
Total the data in an Excel table
Resize a table by adding or removing rows and columns
Filter data in a range or table
Using structured references with Excel tables
Excel table compatibility issues