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.
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.
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.
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.
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.
See only the Delivery Done items are shown now.
You can also filter the table contents with the Text Filters menu.
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.
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.
Conclusion
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!
