Microsoft Office Tutorials and References
In Depth Information
Sorting data by using custom lists
12
Click OK to close the Sort dialog box and sort the data list.
13
Click cell C3 . Then on the Home tab, in the Editing group, click Sort & Filter , and click
Custom Sort to open the Sort dialog box.
14
In the Sort by row, in the Column list, click Revenue .
15
In the Sort on list, click Cell Color .
16
In the new list control that appears in the Sort by row, click On Bottom to have Excel
put the Revenue cells that have no cell color on the bottom.
17
Click OK to have Excel sort the data list.
CLEAN UP Close the ShippingSummary workbook, saving your changes if you
want to.
Sorting data by using custom lists
The default setting for Excel is to sort numbers according to their values and to sort words
in alphabetical order, but that pattern doesn’t work for some sets of values. One example
in which sorting a list of values in alphabetical order would yield incorrect results is the
months of the year. In an alphabetical calendar, April is the first month and September is
the last! Fortunately, Excel recognizes a number of special lists, such as days of the week
and months of the year. You can have Excel sort the contents of a worksheet based on
values in a known list; if needed, you can create your own list of values. For example, the
default lists of weekdays in Excel start with Sunday. If you keep your business records based on
a Monday-through-Sunday week, you can create a new list that has Monday as the first day
and Sunday as the last.
6
To create a new list, enter the list of values you want to use as your list into a contiguous cell
range, select the cells, click the File tab, and then click Options. On the Advanced page of
the Excel Options dialog box, in the General group near the bottom of the page, click the
Edit Custom Lists button to open the Custom Lists dialog box.
Search JabSto ::




Custom Search