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. On the Insert tab, in the Tables group, click Table (or simply press Ctrl + T).

The Create Table dialog box appears.

3.

How to make a table in excel with lines

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.

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 sheet

how to put box in excel