Alpha, numeric, my way, your way … Custom Lists in Excel

August 22, 2005

Custom lists can be created in Excel, to allow custom sorting.

For example, you want to sort in this order – Red, Green, Yellow, Blue. That’s not alphabetical, is it? Create a Custom List and have it your way.

To create the Custom List, go to Tools, Options, click the Custom Lists tab. Click in the List entries input field. Type the list as you want it to sort, pressing Enter after each entry. Click Add when done. The list is added to the Custom lists field. Click OK. Now when you use Data, Sort in a list, you can click the Options button and choose your custom list for sorting.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: