![Create a table in Excel (1) Create a table in Excel (1)](https://i0.wp.com/support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
Try it!
You can create and format a tableto visually group and analyze data.
-
Select a cell within your data.
-
Select Homeand choose
Format as Table under Styles. -
Choose a style for your table.
-
In the Create Table dialog box, confirm or set your cell range.
-
Mark if your table has headers, and select OK.
Want more?
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.