What is a Table in Excel?

A Table is a feature in Microsoft Excel that helps to put a range of data in a rectangular table. It serves features like Filter, Sort, AutoFill, etc. Mostly it is used to keep the data organized. This article discusses how to insert and use a Table in Excel. It also shows multiple applications of a Table in Excel.

Insert a Table in Excel

Here is a dataset with no Excel Table added.

Randomly select a cell from the dataset. I have selected cell A4.

Then click on the Insert tab.

From the Tables group, click on the Table command.

The Create Table window will come along on the screen.

You will see Excel has already selected the cell range automatically.

Check the ‘My table has headers’ checkbox has a tickmark.

Now click on the OK button.

Create Table in Excel

You will see the table is set with a color theme. Change the color theme if you want,

Click on the Table Design tab.

From the Table Styles group, click on the drop-down button.

Now select a style from the vast collection.

I have chosen this blue theme.

Shortcut to Insert a Table in Excel

Press CTRL+T to create a table in Excel.

🔗  65 Shortcut Keys in Excel

Applications of a Table in Excel

The main function of an Excel Table is to Sort, Filter, and apply formulas in the table data quickly.

1. Sort

If the column contents are alphabetic, click on the small down-arrow beside the column header.

There you will find the options to sort the data alphabetically: Sort A to Z and Sort Z to A.

Sort A to Z in a Table in Excel

I have another column for Prices, and the column contents are numeric.

Click on the small down-arrow in the column header. Now sort with: Sort Smallest to Largest and Sort Largest to Smallest options.

Sort Data from a Table in Excel

2. Filter

You can also filter the data from the table in Excel.

Click on the drop-down menu beside the table headers.

You will find the column content names with a checkbox in the bottom part of the drop-down menu.

Keep the tick-mark for only those contents that you want to keep and remove the tick-mark for the rest of the checkboxes.

From the Delivery items, I will only keep the items that have their Delivery Done. So I uncheck the box of Pending Delivery.

Finally, click the OK button.

Filter data from a Table in Excel

See only the Delivery Done items are shown now.

You can also filter the table contents with the Text Filters menu.

Text Filter from a Table in Excel

3. Total Row

You can also count the total number of rows with the table in Excel.

Select the Table Design tab. Then from the Table Styles Options group, checkmark the box of Total Row.

Use Total row for a Table in Excel

You will notice an additional row has shown up below the table with the total number of rows.

4. Sum Values

You can also sum up the values with the table. Like, I want to sum the total amount of price from the Price column.

Select the empty cell at the bottom of the Price column. A down-arrow will appear instantly.

Click on the down-arrow.

Select the Sum command. Here the total value is $337.

How to sum from the Table in Excel


I hope you got an overall idea about how to use a table in Microsoft Excel. It will help you to save time to organize a dataset. Try the feature next time and tell us in the comment section how you like our Blog page. Have a good day!

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *