LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 03:53 PM
Dan W
Posts: n/a
Default Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW .

I was upgraded to Excel 2003 last week. I have just noticed that the
AutoFilter function has moved two "SORT" functions to the top of the
autofilter list. I AutoFIlter a ton and use the keyboard. Alt+Arrow Down on
the autofilter cell then I choose from the list or use "Custom" . When I am
through looking at the results, I key Alt + Arrow Down+ Home which
automatically selected (All) and put the sheets back to its original,
complete form.

Now when I do that Keystroke, it freaking resorted every bit of my data.
The is completely unacceptable. I can do that keystroke in my sleep and
there is no telling what I have unwittingly already screwed up, not to
mention what I will screw up in the future out of habit.

There has got to be an option to get rid of the sort at the top of the
autofilter list. If not, is there something that can be redone in Excel to
get rid of it? This is really Bad

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, why sort function fails when applied to a list of date? Excel heavy user Excel Discussion (Misc queries) 1 January 18th 05 06:37 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
auto filter question Juco Excel Worksheet Functions 0 November 29th 04 02:48 PM
The Auto Filter button lost the column specified option. D Excel Worksheet Functions 1 November 4th 04 11:47 PM
Why can't my macro use Auto Filter when I told the Sheet Protecti. KC Rippstein Excel Worksheet Functions 1 October 28th 04 06:13 PM

All times are GMT +1. The time now is 03:29 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017