How to create a table in excel with multiple columns

Master Excel tables and analyze your data quickly and easily. Learn how to create a table, sort a table, filter a table, and much more.

Create a Table

To create a table, execute the following steps.

1.

Click any single cell inside the data set.

2.

How to insert table in excel cell

How to insert table in excel cell

How to make a table in excel with headers

How to make a table in excel with lines

How to create a table in excel with multiple columns and rows

How to create a table in excel without data

On the Insert tab, in the Tables group, click Table (or simply press Ctrl + T).

The Create Table dialog box appears.

3. Excel automatically selects the data for you. Check 'My table has headers' and click on OK.

Result: Excel creates a nicely formatted table for you.

This may still seem like a normal data range to you but many powerful features are now just a click of a button away.

Sort

To sort by Last Name first and Sales second, execute the following steps.

1.

Excel table example

First, click the arrow next to Sales and click Sort Smallest to Largest.

2. Next, click the arrow next to Last Name and click Sort A to Z.

Result:

Filter

To filter a table, execute the following steps.

1.

Click the arrow next to Country and only check USA.

Result:

Total Row

To display a total row at the end of the table, execute

how to insert table in excel shortcut key

how to insert table in excel from pdf