Creating a Custom Sort List

When you sort column data, Excel sorts numbers according to their values and words in alphabetical order, but that pattern doesn’t work for some sets of values. For example, sorting the months of the year in alphabetical order would put February in front of January. To avoid those errors, Excel comes with four custom lists: days of the week, abbreviations for days of the week, months, and abbreviated month names. You can have Excel sort based on those lists or, if you want to create a custom list of your own, you can do so. Because the day and abbreviated day name lists begin with Sunday, you could create a new list beginning with Monday to reflect your business schedule.

Define a Custom List of Values

  1. Click the Microsoft Office button.

  2. Click Excel Options.

  3. Click Popular.

  4. Click Edit Custom Lists.

  5. Click New List.

  6. Type the custom list you want. Separate each entry by pressing Enter.

  7. Click Add.

  8. Click OK twice to close the Custom Lists dialog box and the Excel Options dialog box.

    Define a Custom List of Values

Sort by a Custom List

  1. Click any cell in the list you want to sort.

  2. Click the Data tab.

  3. Click Sort.

  4. Click the Sort By down arrow and then click the column you want to sort by.

  5. Click the Sort On down arrow and then click the criteria you want to sort by.

  6. Click the Order down arrow and then click Custom List.

  7. Click a custom list.

  8. Click OK to close the Custom Lists dialog box.

  9. Click OK to sort the data list.

    Sort by a Custom List
    Sort by a Custom List
    Sort by a Custom List

    Tip

    Tip

    In previous versions of Excel, you could use a custom list to sort only one column of your worksheet data, and that column had to be the first by which you sorted your data. In Excel 2007, you can sort any number of columns according to the values in a custom list.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.128.226.255