Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Changing default sort order?

  1. #1
    New Member rlarson's Avatar
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I installed Office recently, and Excel seems to remember the first sort criteria that I used to sort the forst time. My problem is that I don't want to sort by this order every time:
    "Sort by: C"
    "Then by: D"
    "Then by: E"

    Is there a setting I can change so that whenever I bring up the sort criteria box, the fields are blank, (or only display one choice, so I don't have to manually choose "none" for 2 boxes??

    Thanks!
    Randy

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To clear the Sort command's "memory" select 2 empty cells and perform a sort.

  3. #3
    New Member rlarson's Avatar
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Mark!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •