Create and format tables
Create and format a table to visually group and analyze data.
-
Select a cell within your data.
Data
-
Select Home > Format as Table.
Table
-
Choose a style for your table.
Table Style
In the Create Table dialog box, set your cell range.
-
Mark if your table has headers, then select OK.
Create a Table
-