Custom Sort Order

  • Thread starter Thread starter Fishnerd
  • Start date Start date
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!
 
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

Similar Threads

Custom Sort order issue 2
Month sorting 3
Sorting in Excel 2
Open File menu sort alphabetical. 6
Pivot Table Sort Order 1
Sorting day names chronologically 5
Pivot Table Sort Issue 1
writing a sort macro 2

Back
Top