"Blank" option to the top of the excel filter options
Is there a way to bring the "Blank" option to the top of the excel filter options as it is shown in the picture below.
In 2010 version of the excel the "Blank" was on the top by default but it went back to the bottom of the list in the next revisions.
Arindam Ghatak commented
Yes this is really a big irritating problem that you scroll down each and every time whenever you want the exception report through filtering the data.
Heather R commented
YES, yes please - I often use filtering to find these error indicators and it's a pain to have to scroll to the bottom of a long list of values.
I've even wondered if it would be possible to just have a 'filter for errors' selection that would grab anything that has one of the standard Excel error messages as a result.
Wyn Hopkins commented
I would also like to see N/A# and any other error at the top of the list