How to Use Excel Filter Shortcut?

How to Use Excel Filter Shortcut?

5 mins read57.1K Views Comment
clickHere
Rashmi
Rashmi Karan
Manager - Content
Updated on Dec 7, 2023 14:21 IST

Excel Filter shortcuts are keyboard combinations that you can use to apply filters to your data quickly and easily. For example, you can use the keyboard shortcut Ctrl+Shift+L to open the Filter dialog box, where you can select the criteria for your filter. The article will explain different ways to use Excel Filter shortcuts, such as filtering by text, numbers, dates, and colors. It will also provide examples of how to use these shortcuts in real-world situations.

2022_08_filter-shortcuts-in-excel-1.jpg

MS Excel is a powerful spreadsheet application with many tools and features to help users manage and analyze data efficiently. The Excel Filter is a feature that can significantly enhance your data manipulation skills. Filters allow you to quickly sort and display specific subsets of data from a larger dataset, making it easier to focus on the information that matters most.

While you can access filtering options through Excel’s Ribbon menu, there are handy keyboard shortcuts that can streamline your workflow and save you valuable time. In this guide, we’ll explore how to use Excel filter shortcuts to filter your data and swiftly improve your overall Excel experience. Whether you’re a beginner or an experienced Excel user, mastering these shortcuts can help you work more effectively with your spreadsheets.

Let’s understand the filter shortcut in Excel with the help of examples. Once you apply the filter, you will see small drop-down icons in your data header.

Content

  1. Turn filters on or off in Excel
  2. Open Dropdown Filter Menu In Excel
  3. Select Menu Items with Arrow Keys
  4. Filter Dropdown Keyboard Shortcut in Excel
  5. Clear Filters In The Range
  6. Clear Filter on a Column
  7. Show the Custom Filter Dialog

Must Read – What is MS Excel?

1. Turn Filters On or Off in Excel

In this example, we will take sales data by region department and payout.

 Turn filters on or off in Excel 1

Read MS Excel Tutorials

To apply a filter to the above data, we will follow the below steps – 

Select a cell in your data range that you want to navigate. If the data range contains blank columns or rows, select the entire cell range.

Go to the DATA tab. Click the Filter option in the Sort & Filter section. 

 Turn filters on or off in Excel 2

Once the filter is applied, the filter dropdowns will appear in the header row of your data.

Explore MS Excel Courses

 Turn filters on or off in Excel 3

Now you can sort the data as per your requirements.

150+ Keyboard Shortcuts In Excel
150+ Keyboard Shortcuts In Excel
Excel users who enter a lot of data with the keyboard can boost their productivity by learning Excel shortcut keys, which allow them to access the program’s commands much faster....read more

Most Popular and Powerful Formulas in Excel
Most Popular and Powerful Formulas in Excel
Excel has various functions ready to process your information to get the desired results. Familiarize yourself with each of them. Once you master various functions, you can create advanced MS...read more

Excel Filter Shortcut

Excel Filter Shortcut 1
Average Function in Excel – Formula and Examples
Average Function in Excel – Formula and Examples
The AVERAGE function is a popular Excel function used for various purposes, such as calculating average sales, average student scores, average monthly expenses, etc. It provides a quick and efficient...read more
Mail Merge in Excel – Shiksha Online
Mail Merge in Excel – Shiksha Online
Mail Merge in Excel is widely used to generate large numbers of documents simultaneously while sticking to an agreed-upon or required format. The unique information for each card or label...read more

2. Open the Dropdown Filter Menu In Excel

Once you enable the filter on your dataset, you can use the dropdown menus in each column header. 

Excel Filter Shortcut

Dropdown Filter Menu In Excel - keyboard shortcut
  • Select a cell in the header row. You will see that each header has a drop-down icon.
  • Press the ALT + Down Arrow key on the keyboard to open the filter menu.
Dropdown Filter Menu In Excel 2

3. Select Menu Items with Arrow Keys

Once you enable the filter, you can use the arrow keys to navigate the filter menu.

  • Use the Enter key and the space bar to select and apply the filter. 

Excel Filter Shortcut

  • Up and down arrow keys ⇒ Select a command
  • Enter key ⇒ Apply the command
  • Space bar key ⇒ Check and uncheck the check box

Sorting in Excel
Sorting in Excel
Sorting in Excel is the process of rearranging data within a worksheet or table based on certain criteria, such as numerical order, alphabetical order, date order, or custom criteria. Let...read more

4. Filter Dropdown Keyboard Shortcut in Excel

Press ALT + Down Arrow to display the dropdown menu. You can use below keyboard shortcuts below to explore the data.

S – Sort from A to Z

O – Sort Z to A

T – Sort by color submenu

C – Transparent filter

I – Filter by color submenu

F – Text Filters

Must Explore – Free MS Excel Courses

5. Clear Filters In The Range 

You can go to the ribbon and click on Data Sort & FilterFilter

Clear Filters In The Range
  • Click the Filter option to see that the boxes no longer have filter icons.
Clear Filters In The Range 2

Excel Filter Shortcut

Clear Filters In The Range shortcut

Must Read – Most Useful Excel Formulas

6. Clear Filter on a Column

To clear the filter on a column, follow the steps below:

  • See that we have applied the filter for China. Select the header from where you want to clear the filter. 
Clear Filter on a Column
  • To clear the filter and revert to the non-filtered data, press Alt + Down Arrow so that the filter menu of the column is visible. 
Clear Filter on a Column 2
  • Press the letter “C.” The filter will be cleared from that column. 
Clear Filter on a Column 3

You may like – MS Excel interview questions

7. Show the Custom Filter Dialog

It is among the most useful keyboard shortcuts when using a data filter. This can be used when you want to filter data using custom criteria. To do this, follow the steps below:

  • Select a cell in the header row.
  • Press the ALT + Down Arrow to display the filter menu for that column.
  • Write the letter “F”.
  • Write the letter “E”.

A custom dialog will appear. The comparison operator will be set to equal.  

Show the Custom Filter Dialog
  • Select the option from the list (such as not equal, etc.) and enter the criteria.
Show the Custom Filter Dialog 2
  • Select AND or OR, then press OK to apply the filter.
Show3 the Custom Filter Dialog
  • You can see that you have the filtered data with 4 applied criteria – is greater than Argentina; is less than – Philippines.
Show the Custom Filter Dialog 4

I hope this article helped you understand how to apply keyboard filter shortcuts. If you want to learn more formulas and functions in Excel, we recommend the following articles –


FAQs

How can you perform an automatic filter in Excel?

To apply a Live Filter, follow these steps: Select the data you want to filter. Select the data you want to filter; Click Data => Filter; Click on the arrow; Choose specific values; Clear (Select All) to clear all checkboxes; and then check the boxes for the specific values.

How to activate and deactivate filters in Excel?

To activate and deactivate filters in Excel - Activate/deactivate the automatic filter. Activate one of the cells in the corresponding cell range. Click the Sort & Filter button on the Home tab, Edit group, and then click the Filter option. Create the desired filters (see below Filter data from a content or a format).

How do you use the advanced filter in Excel?

Advanced criteria are written in a separate range on the spreadsheet and on top of the cell range or table you want to filter. Microsoft Office Excel uses the criteria range separated in the Advanced Filter dialogue box as the source for the advanced criteria.

What is the function of filtering and sorting data in Excel?

Data is sorted to organize and find the data you want quickly. The data is filtered so that only rows that meet the specified criteria are displayed, and rows in one or more data columns that should not be displayed are hidden.

How do you filter data in Excel?

Filter a range of data; Select any cell; Select Data => Filter; Select the column header arrow; Select Text Filters or Number Filters and select a comparison, such as Between; Enter the filter criteria and select OK.

About the Author
author-image
Rashmi Karan
Manager - Content

Rashmi is a postgraduate in Biotechnology with a flair for research-oriented work and has an experience of over 13 years in content creation and social media handling. She has a diversified writing portfolio and aim... Read Full Bio

Comments