Changing default sort order?

rlarson · Mar 20th, 2002, 11:01 AM

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. · Mar 20th, 2002, 11:08 AM

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

rlarson · Mar 20th, 2002, 11:11 AM

Thanks Mark!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 11:01 AM	#1
rlarson New Member Join Date: Feb 2002 Location: Los Angeles, CA Posts: 28	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

Mar 20th, 2002, 11:08 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	To clear the Sort command's "memory" select 2 empty cells and perform a sort.

Mar 20th, 2002, 11:11 AM	#3
rlarson New Member Join Date: Feb 2002 Location: Los Angeles, CA Posts: 28	Thanks Mark!!!