How to Make a Data Table in Excel?

Enter your data in rows and columns with headers in the first row

Select the entire data range

Go to the Insert tab

Click Table

Make sure the My table has headers box is checked if your data includes headers

Click OK

Use the Table Design tab to change the table style if needed

Suggested for You

Trending Today