Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort Preferences Problem
Is there a way to have Excel remember the most recent sort order choices? I
click in three levels to sort and then as soon as I go back to do the same sort again, I get the default that requires all the sort criteria to be reentered. Thanks! Chris |
#2
|
|||
|
|||
If it's something you do over and over again, have you thought of recording a
macro when you do it once? Then you could just run the macro when you need to do it the next time? Chris wrote: Is there a way to have Excel remember the most recent sort order choices? I click in three levels to sort and then as soon as I go back to do the same sort again, I get the default that requires all the sort criteria to be reentered. Thanks! Chris -- Dave Peterson |
#3
|
|||
|
|||
Hi Chris,
If you're talking about the same sheet, I thought they came up the same but I almost always go to Data, Sort anyway so it really doesn't matter. much to me and I guess I don't pay attention or maybe the fact that I always go to Data, Sort does mean that I pay attention and know not to bypass that. The only way to guarantee things work the same is to write a macro and write it as generically as possible so that you can use it in any similar situation. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Chris" wrote in message ... Is there a way to have Excel remember the most recent sort order choices? I click in three levels to sort and then as soon as I go back to do the same sort again, I get the default that requires all the sort criteria to be reentered. Thanks! Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Zip code sort is an Excel problem even when using the special cat. | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
Sort Problem | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) |