Changing default sort order?

[rlarson]

Hi,

I installed Office recently, and Excel seems to remember the first sort criteria that I used to sort the forst time. My problem is that I don't want to sort by this order every time:
"Sort by: C"
"Then by: D"
"Then by: E"

Is there a setting I can change so that whenever I bring up the sort criteria box, the fields are blank, (or only display one choice, so I don't have to manually choose "none" for 2 boxes??

Thanks!
Randy

 

[Mark W.]

To clear the Sort command's "memory" select 2 empty cells and perform a sort.

 

[rlarson]

Thanks Mark!!!