2007/06/14 -
MS Excel - Custom Lists
Ever been faced with a situation where you had to sort an Excel table following a logical order other than alphabetical (e.g. by employee names)?
Well, you can with Excel?s Sort options!
1. First thing, you need to create a list in a specific order (not alphabetical). For example:
2. Select range A1:A6.
3. From the Menu Bar: Tools => Options => Custom Lists => Import => OK
Note: There are already pre-defined lists (e.g. days & months), according to your regional settings.
4. Your list is done!
At any time, you can choose to sort a table by a column where theses names are included.
For example:
1. From the Menu Bar: Data => Sort => Options
2. Select your list from the First key sort order drop-down menu, and click OK.
3. Your table will be sorted according to your list?s order.
Neat Feature: By using the Fill handle with your mouse (click & drag), you can fill adjacent cells with the names contained in your custom list.
|
