Can I save a custom sort order for a specific spreadsheet?

B

BarKay

I would like to use the same sort order for a specific spreadsheet every
time. Can I set a sort order that will display the same every time I select
the sort function within that spreadsheet?

I am using Windows XP and Microsoft Office Excel 2003.
 
J

Joel

Use learn Macro then run the macro every time you need to do the sort.

go to Tools Menu - Macro - Record Macro

then perform your sort.

Next Go to tools menu - macro -Stop recording.


to run macro, again go to Tools Menu - Macro - Macro. You macro will be in
the list of macros to run.
 
Top