In Excel you will find many tools that make it possible to make your work more practical when examining the document. Among them we can create pivot tables that you can use to organize the figures that are recorded in the spreadsheet.
Also, you can sort ascending or descending and in alphabetical order, of course you can also do a custom order. And if you want to Filter, you have to take into account that you will only do it with the data already established, according to the filter you have chosen.
Don’t panic if applying, Sort and Filter some data disappears, it’s momentarily while showing what you just selected. With the filters you can also customize, depending on the value you are applying, or the investigation warrants it, as you will see later.
Ways to Filter table data by font color, cell, or icon sets
Previously you have recorded the data and figures in your spreadsheet, having applied the styles and formatting to your table, perhaps using other Microsoft Excel icons. So now you have your sheet, ready to apply Sort and Filter, follow the steps below to get the correct results in Excel.
- From the Sort & Filter icon
- Apply the colors according to the distribution you expect.
- Select the column or cell, then go to the sort and filter icon, click Filter and a little arrow will appear. These indicate that the filter is already available.
- Press one of the arrows, a window will be displayed, click on Filter by color, and the colors appear immediately, choose the one you want.
- Only the columns and cells that I select will remain, to return, click on the little arrow and when opening select Clear filter from, and it will be restored.
- You can even select all or individually.
- From the Data tab
- Have your document already made and with the colors applied according to the distribution you are looking to expose in your work. It is important to remember this, otherwise you will not be able to mark the filter.
- Click on the cell or column, which you want to apply the filter.
- Go to the Data tab, and choose Filter, you will see the filter arrow in the pop-up window, select Filter by color.
- Specify the color you want, and the data you need to analyze is at your disposal.
- From the Data tab with Advanced Options
- Get ready with your designed spreadsheet, and list with the colors that I already applied to your document.
- Locate yourself in the cell you want to sort and filter,
- Go to the Data tab, select the Filter and Advanced icon and a pop-up window will open where you can do an advanced and specific filter.
- After performing the procedure, you will be able to change the name of the spreadsheet.
How to do if you want to remove the filters?
If you’re new to this tool, you’re likely to be intimidated by using Excel and its icons, and want to undo some steps in the process. That is why we explain how to eliminate the filters, you have two simple and useful options to speed up your work correctly in your job:
- If you are in the Home tab, go to the Sort and Filter icon and click on Filter.
- Another option is to go to the Data tab and choose Filter.
Benefit of using the Sort and Filter icon
Excel is one of the most used applications to carry out work, be it in companies, or at an academic level, or simply to do accounting. Wherever you go, it is important to know how to use Excel because it allows the interpretation and explanation of calculations in an easy way.
Being able to use this tool allows you to work efficiently and perform data analysis that will help you speed up your work. Quickly sort specific figures, you can take advantage of Excel tools to remove or delete duplicate data in Excel with formula and refine your work.
We hope that with this useful guide on how to filter data, you will make Excel your personal assistant; With these steps you will achieve your goal!
