ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I save a custom sort order for a specific spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/134836-can-i-save-custom-sort-order-specific-spreadsheet.html)

BarKay

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.

joel

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