Shortcut to Filter by Cell’s Value in Excel

Bottom line: Learn a quick and useful shortcut to apply a filter based on a cell's value, color, or icon in Excel.

Skill level: Beginner

A Fast Way to Filter for Blanks, Errors, & Specific Values

Filtering for specific values can be a multi-step process in Excel. Especially when filtering for blanks or errors. You might find yourself scrolling to the bottom of the filter drop-down list box to apply these filters.

Fortunately, the right-click menu can save us some time here.

Filter by Selected Cells Value in Excel

To apply a filter for a cell's value:

  1. Right-click a cell that contains the value you want to filter for.
  2. Choose Filter > Filter by Selected Cell's Value
  3. The filter will be applied to the column.
Filter Applied to Column After Filter By Selected Cells Value Right-click Menu

The filters will also be turned on if they are not already. This can save an additional step.

Another advantage is that you don't have to scroll up to the header row if you are not using an Excel Table or freeze panes.

Keyboard Shortcut to Filter by Cell's Value

We can also perform this task with a keyboard shortcut if your keyboard has a Menu Key.

Keyboard Shortcut to Filter by Selected Cells Value

The keyboard shortcut to Filter by the Selected Cell's Value is:

Menu Key, E, V

For me, this is the fastest way to apply a filter for a single value (criteria).

I explain more about the Menu Key in my article on the best keyboards for Excel keyboard shortcuts. I also share the Logitech keyboard that I use (pictured below) in that post.

Menu Key - Right Click Key on Windows Keyboard - Logitech K270

The Menu Key is also one of the fastest ways to Paste Values and I think every Excel user's keyboard should have it.

Filtering for Colors & Icons

There are also options on the right-click menu to filter by the selected cell's: Color, Font Color, and Icon. The Icon is an icon that is created by conditional formatting.

The underlined letters in each of those menu items will be the last letter in the Menu Key, E shortcut.

Filtering for Blanks and Errors

You can use this technique to filter for any single value in a column. I use it most often for blanks and formula errors.

Filter by Selected Cells Value for Formula Errors

It's especially useful if you have a column of VLOOKUP formulas and want to quickly filter to see all cells that are returning an error (#N/A, #REF!, etc.)

Shortcut to Clear a Column Filter

We can also use the right-click menu to clear the filter applied to the column.

The keyboard shortcut to clear the column's filter is:

Menu Key, E, E

Thanks to Naveed for pointing this out in the comments below.

The keyboard shortcut to Clear All Filters in all columns is:

Alt, A, C

I explain more about that shortcut in section #7 of my post on filter shortcuts.

Conclusion

I hope you find this shortcut useful in your daily work. It's one of those that you tend to forget if you don't use it frequently. But can definitely be a time saver that is worth committing to memory.

Check out my article on 7 Keyboard Shortcuts for the Filter Drop-down menus to learn more filter shortcuts.

Please leave a comment below with any questions or suggestions. Thank you! 🙂

12 comments

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

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly