View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CalcTeacher CalcTeacher is offline
external usenet poster
 
Posts: 2
Default Excel "remembering" sort criteria

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?