Know how to filter in excel and make your work more simple and absolutely hassle-free.
If you are working on a big file with a lot of data and content, finding something can be very difficult. It will become a big task for you to find out a number or figure from this huge worksheet. But with the help of filters, one can narrow down the research and find exactly what they are looking for.
Let us first know what a filter really is. A filter is a feature in Excel that helps in displaying the relevant entries temporarily. The need for this feature is to focus on important data.
How To Filter In Excel
Let us see how we can do it.
There are three methods to add filters in excel and they are as follows:
- With the filter option under the Home tab
- With the filter option under the Data tab
- With the shortcut key
The following table shows the invoices issued to the buyers of different cities. We want to filter the data using different methods.
How to split cells in Excel
How to separate text in Excel
With Filter Option Under the Home tab
Go to the “filter” option under the “sort and filter” in the Home tab.
Step 1: Select the data and click “filter” under the “sort and filter” drop-down.
Step 2: The filters are added to the selected data range. The drop-down arrows, within the red boxes in the image below are filters.
Step 3: Click the drop-down arrow of the column “city” to see all the different names of the cities.
Step 4: To see the invoice values of “Delhi” only, select “Delhi” and uncheck all the remaining boxes.
Step 5: The data for the city “Delhi” is filtered and now can be seen.
How to merge cells in Excel
How to unmerge cells in Excel
With Filter Option Under the Data tab
In the Data tab, there is a “filter” option under the “sort and filter” section, as shown in the following image.
Simply use this option to filter the data and your desired result would come.
With the Shortcut key
This is a good way to speed up the daily tasks. Just select the data and add the filter using any of the following shortcuts:
- Press the keys “Shift+Ctrl+L” together.
- Press the keys “Alt+D+F+F” together.
Microsoft Excel is one of the oldest spreadsheet software programs, and it has gone through several upgrades and fixes. This robust spreadsheet program enables us to carry out a variety of tasks, from simple ones like the average computation to more complex ones like concatenation in Excel.
EasySheet is a tech blog that features amazing Excel hacks, tips, and tricks. Our goal is to make Excel accessible to beginners and provide them with solutions to all of their problems using the EasySheet.
If you require assistance with Microsoft Office products, such as Excel, Word, PowerPoint, Publisher, or anything else, we are the best place to turn.