Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
- Power Bi (35+)
Table of Contents
Excel Filter Keyboard Shortcut
In Excel sorting and filtering data is a very important and common task. With the use of this, we can see the data category wise. For example, if you want to see the data/record of a class subject wise or sales data from the dozen of stores that you need to keep track of, you will be able to find the data quickly that you need.
With filtering data quickly you can easily navigate through menus or clicking through a mouse in less time. In this article, we discuss keyboard excel shortcuts used for filter
How to Use Keyboard Shortcut For Filter in Excel?
Let us understand Filter Shortcut in Excel with the below examples.
Example #1 – Turn Filters ON or OFF in Excel
We have given below sales data region wise.
For this follow below steps:
- First, select a cell in your data range. If the data range contains any blank columns or rows then better to select the entire range of cells.
- Go to the DATA tab then, click on Filter option under the Sort & Filter section. Refer below screenshot.
- We also can use the Keyboard Shortcut CTRL+SHIFT+L for turning On/Off the filters.
- Once applying the filter, the drop-down filter menus will appear in the header row of your data. Refer below screenshot.
Example #2 – Opening the Drop-down Filter Menu in Excel
Once the filter has enabled on your data, you can use the drop-down menus on each of the column headers. Follow below steps for doing this:
- Select a cell in the header row. As we can see that every cell contains drop down an icon like the image then, Press ALT + down arrow key on the keyboard to open the filter menu like below screenshot.
- As we can see in the above image, there are a lot of keyboard shortcuts available in the filter menu.
Example #3 – Select Menu Items Using Arrow keys
Once the excel filter is enabled, we can use arrow keys to navigate the filter menu. Use Enter and Spacebar key to select and apply to filter. Remember below points:
- Press the Up and Down arrow keys to select a command.
- Press Enter Key to apply the command.
- Press the Spacebar Key to check and uncheck the checkbox.
Example #4 – Drop Down Menu Keyboard Shortcut for Filter in Excel
You must first press the ALT+ Down Arrow key to display the drop-down menu. With this you can one of the following:
- S – Sort A to Z
- O – Sort Z to A
- T – Sort by Color submenu
- C – Clear filter
- I – Filter by Color submenu
- F – Text Filters
- E-Text Box
Example #5 – Clear All Filters in the Current Filtered Range in Excel
Press shortcut key ALT+Down Arrow+C to clear all the filters in the current filtered range. It will clear all the filters in all the columns. After that, all rows of your data will be displayed.
For this, you also can use Excel ribbon option.
Example #6 – Clear Filter in a Column
To clear filter in a column, follow below steps:
- Select a cell in the header row and press Alt+Down Arrow to display the filter menu for the column.
- Press the letter “C” to clear the filter.
Example #7 – Display the Custom Filter Dialog Box
When you want to filter the data by using custom criteria, you can use a custom filter box. For this follow below steps:
- Select a cell in the header row.
- Press ALT+Down Arrow key for display the filter menu for the column.
- Type the letter “F”.
- Type the letter ”E”.
- Then a custom dialog box will appear which sets the comparison operator to equal. See below screenshot.
- Select the option from the list (such as not equal etc.) and enter the criteria.
- Select And or Or then, Press OK to apply the filter.
It Displays Filtered Data.
Things to Remember About Filter Shortcut in Excel
- If you are using Excel tables feature, then you can apply the filters on more than one table range at a time in the same worksheet.
- With using filters keyboard shortcut in excel you can save a lot of time.
- Use the keyboard shortcuts as explained in this article, are the fastest way to work with the filter menus.
This has been a guide to Filter Shortcut in Excel. Here we discuss how to use keyboard shortcut for a filter in excel in different ways along with practical examples and downloadable excel template. You may learn more about excel from the following articles –