You can use this technique to filter for any single value in a column. The underlined letters in each of those menu items will be the last letter in the Menu Key, E shortcut. The Icon is an icon that is created by conditional formatting. There are also options on the right-click menu to filter by the selected cell's: Color, Font Color, and Icon. The Menu Key is also one of the fastest ways to Paste Values and I think every Excel user's keyboard should have it.

I also share the Logitech keyboard that I use (pictured below) in that post. I explain more about the Menu Key in my article on the best keyboards for Excel keyboard shortcuts. The keyboard shortcut to Filter by the Selected Cell's Value is: Menu Key, E, Vįor me, this is the fastest way to apply a filter for a single value (criteria). We can also perform this task with a keyboard shortcut if your keyboard has a Menu Key. Keyboard Shortcut to Filter by Cell's Value This can save an additional step.Īnother 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.

The filters will also be turned on if they are not already. The filter will be applied to the column.Choose Filter > Filter by Selected Cell's Value.Right-click a cell that contains the value you want to filter for.You might find yourself scrolling to the bottom of the filter drop-down list box to apply these filters.įortunately, the right-click menu can save us some time here. Especially when filtering for blanks or errors. Bottom line: Learn a quick and useful shortcut to apply a filter based on a cell's value, color, or icon in Excel.Ī Fast Way to Filter for Blanks, Errors, & Specific Valuesįiltering for specific values can be a multi-step process in Excel.

Excel shortcut keys filter