AutoFilter in Excel filters out different desired data types in a data range or column. An inbuilt button is available in the “Home” tab in the editing section. We can also use the keyboard shortcut “CTRL + SHIFT + L.” This feature makes the work easier for any user as one can filter out the required data.
For example, suppose you are an owner of a toy shop and just received the new deliveries of ordered toys. You are required now to stock the shop shelves. The toy description describes the varied size and brands. For the owner, while stocking, these values are essential. So accordingly, you add two columns to the Excel sheet for “Size” and “Brands.” In filter, Excel is versatile. AutoFilter Excel feature will help you turn values in an Excel column into filters based on the column’s cells and allow you to view particular rows while hiding other rows.
Excel AutoFilter is an easy way to turn the values in Excel columns into specific filters based on the cell content. The AutoFilter in Excel enables us to filter our data as we desire in one, two, or more columns at once.
Excel AutoFilter allows us to slice and dice our data as per our requirements. We can filter based on our choices from a list or search for the specific data we want to find. The rows which do not meet the criteria of the filters will be hidden.
In simple words, AutoFilter in Excel allows us to view specific rows in Excel while hiding the other rows. When Excel AutoFilter is added to the row’s header, it gives us a drop-down menu in the header row. In addition, it provides us with several filter options, which we will discuss in this topic.
AutoFilter in Excel allows us to view specific rows while hiding the other rows. When Excel AutoFilter is added to the row’s header, it gives us a drop-down menu in the header row.
AutoFilter in excel gives us multiple filter options such as :
The first four are the number of filters, while the remaining are text filters.
There are two ways to use the auto filter in Excel:
1. In the “Data” tab, click on “Filter” under the “Sort & Filter” section.
2. Excel shortcutExcel ShortcutAn Excel shortcut is a technique of performing a manual task in a quicker way.read more – Press Ctrl + Shift + L.
The options specify which rows of the Excel workbook are to be displayed.
Let us learn the use of Excel AutoFilters with a few examples:
You can download this Auto Filter Excel Template here – Auto Filter Excel Template
A real estate website has different property types data, including residential and commercial. They have specific brokers and photographers who clicked the images for those real estate properties. The company also maintains the picture count in the properties taken by the photographer.
The task is to find which city has a picture count of 33 and broker Prateek has that property.
By Excel AutoFilter, we have chipped our data. Therefore, the data which did not meet our criteria, i.e., picture count other than 33 or broker other than “Prateek,” is hidden.
We have our desired data as we wanted.
Some students have scored marks in their annual exams in a teacher’s class. For example, the teacher wants to know which student has scored above 50 in Maths and their total is above 300.
In continuation with example 2, we can also use a custom filter.
But first, what is a “Custom Filter”?
A “Custom Filter” is an Excel filter option that allows us to put certain conditions to get our values. For example, in example 2, the condition marked above 50 in mathematics or total above 300 in the total marks.
Let us learn custom filter by example 2.
Write 50 in the box where there is the text “is greater than.”
We have our result where the marks in mathematics are above 50, and the total is above 300.
This article is a guide to Auto Filter in Excel. Here we discuss how to use AutoFilter in Excel along with Excel examples and downloadable Excel templates. You may also look at these useful Excel tools: –
Rotating Hydraulic Cylinder Exporters Flame Retardant Knit Fabric 36 Cell Solar Panel Cast aluminum furniture parts high voltage cable wholesale fruit powder tempered float glass Wholesale Camping Chairs Different Kinds of Camping Chairs rubber oil seal nitrile cleanroom gloves Mercedes Benz Brake Discs and Pads scuba mask wholesale Wholesale 104 Holes Plant Starter Trays for sale Achromatic Lens Aromasin Powder