![]() |
Can I save a custom sort order for a specific spreadsheet?
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. |
Can I save a custom sort order for a specific spreadsheet?
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. "BarKay" wrote: 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. |
All times are GMT +1. The time now is 09:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com