Create 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?
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
