I believe it will remember if you always select the same total range. But if
the next time you come in you wind up selecting an extra column or not all
the columns you did the first time around, then it can't "remember" the sort
for that range because you've technically specified a new range.

The way I always ensure it remembers is by naming my sort range to something
like "EntireList"...then I know I am always selecting the same range and,
consequently, it always remembers my sort criteria for that range.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"CalcTeacher" wrote:

Sometimes when I do a sort in Excel 2003 (say by column AC with no header
row) and then return to that sheet at a later date, Excel shows those
criteria as a default selection for a sort. However, other times, with other
sheets it always defaults back to Column A with a header row.

How can I get Excel to always "remeber" the las sort criteria I used on a
particular sheet?