7 Keyboard Shortcuts for the Filter Drop Down Menus

This post will explain 7 keyboard shortcuts for the filter drop down menus. This includes my new favorite shortcut, and it's one that I think you will really like!

This post will explain 7 keyboard shortcuts for the filter drop-down menus.  This includes my new favorite shortcut, and it's one that I think you will really like!

The Filter drop-down menus (formerly known as Auto Filters in Excel 2003) are an extremely useful tool for sorting and filtering your data.  When the Filters are applied you will see small drop-down icon images in the header (top) row of your data range.

Excel Filter Drop Down Menus Excel 2013

These menus can be accessed with keyboard shortcuts, which makes it really fast to apply filters and sorting to different columns in your table.  So let's take a look at these shortcuts.

#1 – Turn Filters On or Off

Ctrl+Shift+L is the keyboard shortcut to turn the filters on/off.  You can see this shortcut by going to the Data tab on the Ribbon and hovering over the Filter button with the mouse.  The screen tip will appear below the button and it displays the keyboard shortcut in the top line.  This works with a lot of buttons in the ribbon and is a great way to learn keyboard shortcuts.  See the image below.

Data Filters Screen Tip Keyboard Shortcut Excel

To apply the drop down filters you will first need to select a cell in your data range.  If your data range contains any blank columns or rows then it is best to select the entire range of cells.

Once the data cell(s) are selected, press Ctrl+Shift+L to apply the filters.  The drop down filter menus should appear in the header row of your data, as shown in the image below.

Ctrl+Shift+L Excel Turn Filters On Off

#2 Display the Filter Drop Down Menu

Alt+Down Arrow is the keyboard shortcut to open the drop down menu.  To use this shortcut:

  1. Select a cell in the header row.  The cell must contain the filter drop down icon. Excel Filter Drop Down Icon Unfiltered
  2. Press and hold the Alt key, then press the Down Arrow key on the keyboard to open the filter menu.
Alt+Down Arrow Excel Display Filter Drop Down Menu

Once the drop down menu is open, there are a lot of keyboard shortcuts that apply to this menu.  These shortcuts are explained next.

Bonus Tip: If you are using Excel Tables, and I highly recommend you do, you can press Shift+Alt+ Down Arrow from any cell inside the table to open the filter drop-down menu for that column.

Open Filter Drop-down Menu from Table Cell -Shift-Alt-Down Arrow

This shortcut was introduced in Excel 2010 for Windows, and works in all newer versions as well.

#3 Underlined Letters & Arrow Keys

The underlined letters in the drop-down menu are the shortcut keys for each command.  For example, pressing the letter “S” on the keyboard will Sort the column A to Z.  You must first press Alt+Down Arrow to display the drop down menu.  So here are the full keyboard shortcuts for the filter drop down menu:

  • Alt+Down Arrow+S – Sort A to Z
  • Alt+Down Arrow+O – Sort Z to A
  • Alt+Down Arrow+T – Sort by Color sub menu
  • Alt+Down Arrow+I – Filter by Color sub menu
  • Alt+Down Arrow+F – Text or Date Filter sub menu
Filter Drop Down Menu Keyboard Shortcuts

#4 Check/Uncheck Filter Items

The up and down arrow keys will move through the items in the drop down menu.  You can press the Enter key to perform that action.  This requires the drop down menu to be open by first pressing Alt+Down Arrow.  See the image in #3 above for details.

Starting in Excel 2007, a list of unique items appears at the bottom of the filter drop down menu with check boxes next to each item.  You can use the up/down arrow keys to select these items in the list.  When an item is selected, pressing the space bar will check/uncheck the check box.  Then press Enter to apply the filter.

Space Bar Select Items in Filter Drop Down Menu Excel

#5 Search Box – My New FAVORITE

Starting in Excel 2010 a Search box was added to the filter drop-down menu.  Excel 2011 for Mac users also get this feature.

This search box allows you to type a search and narrow down the results of the filter items in the list below it.

Alt+Down Arrow+E Filter Search Drop Down Menu Excel

When the filter drop down menu is open, you can press the letter “E” on the keyboard to jump to the search box.  This places the cursor in the search box and you can begin typing your search.

Alt+Down+Arrow+E is the shortcut to open the filter drop down menu and jump directly to the search box.

I just learned this shortcut and it is my new favorite because it makes it so fast to type and filter exactly what you are looking for in the list.  Prior to learning this I was using the down arrow key to get to the search box.  This required me to press the down arrow key 7 times to get to the search box.  Now I can do the same thing in one step by pressing the letter “E”.  What a time saver!

Bonus – Jump to the Checkbox List

If you want to jump down to the checkbox list below the Search box, you can just press Tab after Alt+Down Arrow, E.

Keyboard Shortcut to Jump to Checkbox List in Filter Drop-down Menu

So the full keyboard shortcut is: Alt+Down Arrow, E, Tab (or Down Arrow)

You can use either the Down Arrow or Tab keys.  Down Arrow will probably be easier since you just pressed Down Arrow to open the filter menu.

However, if the column contains dates then you need to press Tab twice.  There is an additional drop-down menu to search by Year, Month, Date.  Down Arrow opens that menu and selects each item.

Therefore, it's probably best to get used to using Tab to get there since it works in all situations.

Once you press the shortcut, focus will be set to the (Select All) checkbox in the list box.  You can then use the following shortcuts to navigate and select the checkboxes.

  • Space Bar checks/unchecks items.
  • Up/Down Arrows to select items.
  • End jumps to last item.
  • Home jumps to first item.
  • Page Up/Down to jump to first/last item in view.

#6 Clear Filters in Column

Alt+Down Arrow+C will clear the filters in the selected column.  Again, this is a combination of the Alt+Down Arrow to open the filter menu, then the letter “C” to clear the filter.

Alt+Down Arrow+C Clear Filter in Drop Down Menu Excel

This would be the same as pressing the (Select All) checkbox in the item list.  The next shortcut will explain how to clear all the filters in all columns.

#7 Clear All Filters

Alt+A+C is the keyboard shortcut to clear all the filters in the current filtered range.  This means that all the filters in all the columns will be cleared, and all rows of your data will be displayed.

Alt+A+C Clear All Filters Excel

I add the Clear Filter button to the Quick Access Toolbar (QAT) and would highly recommend that you do this.  It serves two purposes that are very helpful.

  1. You can quickly press the button in the QAT to clear the filters.  If you are a mouse user this means you don't have to navigate to the Data menu to access the button.  You can also use keyboard shortcuts to press the buttons in the QAT.  See my articles on how to setup the Quick Access Toolbar  and how to use the QAT's keyboard shortcuts for instructions on this.
  2. Use the button to visually see if any filters are applied.  This is the most important benefit to me.  If any filters are applied to the filter range, then the Clear Filter button in the QAT will show color (enabled).  If no filters are applied then the button is grayed out (disabled).  See the image below for details.
    _Clear Filter Button Quick Access Toolbar QAT Filter Applied or Cleared
    Debra Dalgleish has a great post and video with a few additional tips to Clear Excel Fitlers with a Single Click over at the Contextures blog.

#8 Filter for Blank or Non-blank Cells or Rows

Alt+Down Arrow+F+E+Enter will filter for blanks cells in the column.

Filter For Blanks Cells or Rows in Excel

The F,E combo opens the Custom AutoFilter menu where you can type a search term.  The box is blank by default.  So if you just hit Enter when the Custom AutoFilter menu opens, the column will be filtered for blanks.

This is another one of my new favorites!  It's much faster than unchecking the Select All box, then scrolling to the bottom of the item list.

You can also filter for Non-blanks using the shortcut Alt+Down Arrow+F+N+Enter.  This opens the Custom AutoFilter menu and sets the comparison operator to does not equal.  The criteria is blank by default, so this applies a filter for non-blank cells.  Thanks to Nilesh for leaving a comment and inspiring this one!

Bonus Tip

Typically you can only have one range filtered on a sheet at a time.  This means that if you have more than one range of data on a sheet, you can not apply the Filters menus to both ranges.

If you use the new Excel Tables feature (introduced in Excel 2007 and available for 2011 for Mac) then you can apply Filters to each table in the same worksheet.

Excel Tables Multiple Tables and Filters on Same Worksheet

Checkout my video tutorial on Tables to learn more about all the great time saving benefits they have to offer.

Want More? – Download the Workbook

I hope you've learned some new tricks that will save you time when working with Filters.  In my opinion, the keyboard shortcuts are the fastest way to work with these menus.  I encourage you to practice these techniques, and also share them with a friend that might benefit.

I have also created a free workbook that contains over 25 keyboard shortcuts for the Filter Menus. The workbook is organized by topic and contains images that will help you learn the shortcuts.  It also includes a data table where you can practice the shortcuts.

Filter Drop-down Shortcuts Workbook Sample Page
Filter Drop-down Shortcuts Workbook Sample Page

Please fill out the form below to download the file immediately.

You will also have the option to subscribe to my free email newsletter to stay updated with new articles and videos that will help you learn Excel.  After confirming your subscription you will be able to download my “10 Excel Pro Tips” eBook.  It's all free!

Challenge Question

What does the following keyboard shortcut sequence do?  The selected cell must be in the header of a filtered range.

Alt+Down Arrow+E, Down Arrow, Space Bar, Shift+End, Space Bar, Enter

Please leave a comment below with your answer.  Thanks!


Your email address will not be published. Required fields are marked *

  • Not sure if this was mentioned in any other post or if you already knew but another way to know if you have a filter applied is, on the left-hand-side, the numbers indicating what your row your on turn blue.

  • I have an Office 365 version of Excel and I want to show a certain area of a filtered list to a certain person and let them edit that section. I have several different people I want to show different areas of the same list. I found out that although protecting the workbook and the worksheet with various locked fields and filters, they can still use alt+arrow down in an editable field and see the rest of the contents that is being filtered out. Granted they would have to painstakingly go through line by line and row by row to recreate what is there, but it’s possible and I don’t like that. Is there a better way to do this?

  • The shift + alt + down in a table doesn’t work, it minimizes the excel window instead. Any workaround on this ?
    Thanks .

  • Anyone here know how to expand a plus sign in the filter, if the drop down is on calendar dates, in the drop down it will show monthly. How can I view the dates inside a particular month.Thanks!

  • Filter drop down option is not working ..i had to press altr down arrow from num keyboard..please help

  • I’m a huge fan of tables, so I put almost everything into tables. In that case I will “always” use the
    ++ shortcut since I’ll be in the row rather than jumping to the column head.
    There are more like 18 or so shortcuts, not just 7.
    PS: in one place you wrote “Page+Down” instead of “Page Down”

  • Actually, it is more like 18+ keyboard shortcut tips …

    Since I am a total fan of Excel tables, I put almost everything in Excel Tables these days, the shortcut to access filter is
    ++ … plus additional keys

    Note: in one spot you wrote Down+Arrow

    (this may be a duplicate)

  • How to go to Next Filtered Value using Excel Keyboard Shortcuts?

    e.g. When filtered, a column has suppose

    7000 nos Product A,
    3275 nos Product B,
    5000 nos Product A,
    2123 nos Product C and so on Randomly.

    I want to go to

    First Product A then press key(s) to go to
    Next Product B, then press key(s) to go to
    Next Product A, then press key(s) to go to
    Next Product C, then press key(s) etc.

  • Is there any option to group select within a filter list? For example I have a column with filter on and 100 possible filters. I want to select checkbox for a particular filter. Then select checkbox 10 filters away. I want checkbox select all the filters between the two filters. This traditionally used holding shift when selecting items when managing files.

    Clear all filters with a hotkey, which Excel does not show as a tooltip on the ribbon button (DERPPPP). Great stuff thank you!

  • *smile*, the problem is I have a weekly dataset created by a database administrator that includes the kitchen sink. I cannot get this database administrator to do anything other than the bulk download. But, I can take fifteen minutes and sort the data with custom filters to get what I want. I would like to copy these filters and paste into the new sheet. Is this possible? So far I cannot figure it out.

  • Can you tell me how to get automatically get back to the bottom of the list after clearing a filter? Everytime I clear the filter I’m back at the top of the list and must scroll or page down to get back to where I’m working.

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter