Re: Need to scroll up to access the ascending/descending option in fil

I am/was aware of the Sort Ascending and Descending options in the Autofilter
list, but consider these to be secondary functions so they don't need to be the
default selections in a filter list as far as I am concerned.

Others will differ, but won't change my mind.

You wanna sort....sort

You wanna filter....filter.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 16:25:28 -0500, Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
wrote:

Except that xl2003 (IIRC) added Sort Ascending and Sort Descending to the top of
the autofilter list.

I'm not sure if this will help the original poster, but...

I've added a ShowAll button to my favorite toolbar. I can click that to see all
the rows in the filtered range.

And the two sort options are right at the top of the drop down.

Tools|Customize|commands tab|data category
scroll down looking for "Show All" and drag it to your toolbar.

Gord Dibben wrote:

The primary use of Autofilter is for filtering values, not sorting, so values to
filter naturally are listed first as would seem logical.

Data>Sort is for sorting.

Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 03:07:01 -0700, MichelleBest
<MichelleBest@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I may be alone here, but I use filters on Excel sheets quite a lot, mainly
for the ease of sorting data without having to select the cells first.

Anyway, I find it quite annoying that everytime I want to sort my data in
ascending or descending order, I access the filter and then have to scroll
up. Why isn't it just the first option in the drop down list by default? I
am being very picky here, but if anyone else experiences this frustration,
let it be known please!

----------------
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/community/en-us/default.mspx?mid=c80bbca6-ffa5-4ac6-b808-07116d26734a&dg=microsoft.public.excel.work***.functions

.

Loading