![]() |
Custom Sort Order
Is there any way to make a custom Sort Order so that excel will sort
diiferently then the default? In other words, create some sort of rule that it will follow instead of the default. Kind of like when excel sorts the month names in month order instead of alphabetical order. Thanks! |
Custom Sort Order
Make up your list on a worksheet. Go to Tools | Options | Custom Lists and import and add. When sorting you must specify the custom list - click the "options" button in the Sort dialog box to do that. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming - check out Special Sort) "Fishnerd" wrote in message Is there any way to make a custom Sort Order so that excel will sort diiferently then the default? In other words, create some sort of rule that it will follow instead of the default. Kind of like when excel sorts the month names in month order instead of alphabetical order. Thanks! |
Custom Sort Order
Thanks so much!
"Jim Cone" wrote: Make up your list on a worksheet. Go to Tools | Options | Custom Lists and import and add. When sorting you must specify the custom list - click the "options" button in the Sort dialog box to do that. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming - check out Special Sort) "Fishnerd" wrote in message Is there any way to make a custom Sort Order so that excel will sort diiferently then the default? In other words, create some sort of rule that it will follow instead of the default. Kind of like when excel sorts the month names in month order instead of alphabetical order. Thanks! |
All times are GMT +1. The time now is 06:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com