We work with a xls document on a daily basis, and the user's perform a
repeated sort function on that document multiple times a day. Appearently,
Excel used to save what you last sorted for and would also leave the "Header
Row" circle checked, after you closed the app... Now, neither is saved... So
I am just wondering if there is a way to have excel remember what was sorted
last, how it was sorted and to sort it with a header row with out having to
reset all those settings every time you do a sort...?

Thanks!

What version of Excel are you running? I have 2003 and it seems to remember
my sort criteria as long as I have one of the cells selecting within the
sorting range.

"Sterd" wrote:

We work with a xls document on a daily basis, and the user's perform a
repeated sort function on that document multiple times a day. Appearently,
Excel used to save what you last sorted for and would also leave the "Header
Row" circle checked, after you closed the app... Now, neither is saved... So
I am just wondering if there is a way to have excel remember what was sorted
last, how it was sorted and to sort it with a header row with out having to
reset all those settings every time you do a sort...?

Thanks!