| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort order on very large spreadsheet. | Excel Discussion (Misc queries) | |||
| how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) | |||
| Isolating a custom toolbar to a specific spreadsheet | Excel Discussion (Misc queries) | |||
| Sort order for chart only and not on spreadsheet | Charts and Charting in Excel | |||
| Sort order for graph only and not spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
