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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting day names chronologically 5
Sorting Spreadsheet Help 4
Can I save different sets of sort criteria for a spreadsheet? 2
sort part of a filtered spreadsheet 1
Custom Sort 1
in 2007, how come the sort does not default after I save a file? 1
Macros Automatically Sort 5
Sorting in Custom Alphabetical Order 2

Back
Top