Custom Sort Order

F

Fishnerd

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!
 
J

Jim Cone

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!
 

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

Top