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/comm...et.f unctions

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

DataSort is for sorting.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 03:07:01 -0700, MichelleBest
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/comm...et.f unctions

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.

DataSort is for sorting.

Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 03:07:01 -0700, MichelleBest
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/comm...et.f unctions

--

Dave Peterson

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
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.

DataSort is for sorting.

Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 03:07:01 -0700, MichelleBest
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/comm...et.f unctions

To be honest, each time I see those Sort options in that list, it's like the
first time I see them.

"Hey, look at that. They added Sort options to the Filter dropdown!"

(I don't use them either. Something about learning something new????)

Gord Dibben wrote:

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
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.

DataSort is for sorting.

Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 03:07:01 -0700, MichelleBest
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/comm...et.f unctions

--

Dave Peterson

It's an "old dog" thing in my case.



On Wed, 21 Jun 2006 20:00:18 -0500, Dave Peterson
wrote:

To be honest, each time I see those Sort options in that list, it's like the
first time I see them.

"Hey, look at that. They added Sort options to the Filter dropdown!"

(I don't use them either. Something about learning something new????)

Gord Dibben wrote:

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
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.

DataSort is for sorting.

Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 03:07:01 -0700, MichelleBest
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/comm...et.f unctions

Gord Dibben MS Excel MVP