When a worksheet has the Data Filter applied, the drop-down list has the
option "(Select All)" listed first and the option "(Blanks)" listed last. In
a column that has many unique entries, scrolling down to select/unselect
"(Blanks)" or scrolling back up the list to select/unselect "(Select All)" is
annoying. If these options were fixed at the top, then the user only has to
scroll through the data in the list. The "(Select All)" and "(Blanks)"
selections are always available, so if the user decides that the "(Select
All)" or "(Blanks)" selection should be changed, it will be much easier to
do.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Blanks and Non-blanks are only visible in the drop-down if there are
any in the filter range. Similarly, errors are listed at the bottom,
but only if they exist in the column. The options All, Top 10, and
Custom will apply in all cases.

Pete

On Nov 13, 6:11*pm, THendr2929
wrote:
When a worksheet has the Data Filter applied, the drop-down list has the
option "(Select All)" listed first and the option "(Blanks)" listed last. *In
a column that has many unique entries, scrolling down to select/unselect
"(Blanks)" or scrolling back up the list to select/unselect "(Select All)" is
annoying. *If these options were fixed at the top, then the user only has to
scroll through the data in the list. *The "(Select All)" and "(Blanks)"
selections are always available, so if the user decides that the "(Select
All)" *or "(Blanks)" selection should be changed, it will be much easier to
do.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm....mspx?mid=e383....