+ Reply to Thread
Results 1 to 3 of 3

Sort defaults not saved

  1. #1
    Registered User
    Join Date
    08-06-2007
    Posts
    13

    Sort defaults not saved

    Program behaviour question:

    For some reason the data menu "sort" function is not sticking with the last "sort by", "then by" criterea I selected from the previous time I used the function. I am 100% certain it used to keep the columns and settings I last used which is slightly annoying.

    Can anyone help?

    Ta

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Badger123,

    The Data sort will remember your last settings as long as the same range is selected. Once you select another another cell or range, the sort data is reset to the system defaults.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    08-06-2007
    Posts
    13
    Hello Leith

    That's odd because I used to edit the spreadsheet by selecting cells and editing them and then doing the sort function and I'm sure the same sort criterea kept coming up because I used to think "that's convenient".

    Is there any circumstances where the system defaults would depend on some other variable setting??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1