It is well-known that Microsoft Excel can sort your data in every way you need. But let’s go to basics, to the primary tool that can achieve your information and every kind of content you have, to categorize and analyze it properly: Let’s talk about tables and how to use them.
Accessing tables in Excel is quite simple, but first, you need to enter the titles or headers you want to watch on it. Once you have it, you ought to do the following:
The other option you can use after selecting the range where you want the table is by going into the “Insert” tab, searching the “Tables” group (which is the first one), and clicking on the third option named “Table.” Afterward, a pop-up dialog box will appear, and you must confirm your selection by pressing the “OK” button.
In both cases, don’t forget to mark in the “My table has headers” checkbox option so Excel can recognize them. Usually, the first row of your selection will be read as the title. So, if you don’t check it, Excel will assign them by Default as “Column 1,” “Column 2,” and so on to allow you to edit them later.
Notice that once you apply the table, it has been named by default as “Table 1” (if the first on the worksheet). To change it, you just need to click on the new contextual tab called “Table Design,” check the name at the very left of the “Properties” group, and rename it.
In the same tab, in the center of the ribbon, you’ll find the “Table Style Options'' group with some checkboxes that allow you to show or hide. Thus, when you check any of those items, you will enable what you will display on the table.
Note: If you mark the “banded columns” checkbox, you will see the titles of each column even if you scroll down:
In addition to all the above, something extraordinary about tables is that you can sort your data according to each column's filters. So, go to the headers and click on the dropdown list option at the right-hand corner of each cell.
Notice, then, that there are three principal options:
These are the basic ones, and especially the last one (sort by color) can be extremely useful when working with the Data Validation Feature also by color.
When using the “Filters” that correspond to the second section of the display options, you can access the following options:
Each of these will bring up a dialog box you must complete so your table can do its job. Thus, don’t worry if you need a specific item you don’t remember; use this filter, and you will be able to find out what you need.
Finally, the last option is to check or uncheck the items you have in the specific column you selected. This will just show you what you have marked and avoid the rest.
There you go! Now you can use a table and sort your data according to your needs and preferences. Try it yourself and don’t forget to choose a nice color style. Good luck!