In Excel 2010 when I turn on the filter and click on the down arrow "Select All", and therefore all choices, is selected. Turning off all choices is as easy as unchecking "Select All". However sometimes I am so focused on looking for a specific value I forget to uncheck it. Is there an easy (non macro, non VBA) way to have none of the choices checked when you click on the down arrow?
In the example I really only want to filter to "31". Other then scrolling back up, uncheck "Select All" then scrolling down to find "31" again is there another option. This is particuallry a pain when you have hundreds of options in the list.