Page 49 - Excel Data Analysis

03 537547 Ch02.qxd 3/4/03 11:47 AM Page 35

ORGANIZE WORKSHEET DATA 2

With custom sorts, Excel uses the order of the By default, sorts in Excel are not case-sensitive. For
values in the list to determine how to sort your example, if the data you are sorting includes the
data. Excel sorts the records that match the list values milk and Milk, Excel treats them as identical
first and then sorts the remaining items in values, even though the M is capitalized on the
ascending order at the list's bottom. For second word. If you want to perform a case-
example, if your custom list contains the values sensitive sort, click the Options button in the Sort
High, Medium, and Low, Excel places the records dialog box to display the Sort Options dialog box.
with the value High first, followed by the When you click the Case sensitive option (
Medium values, and finally those with a value of changes to ), Excel makes all three sorts
Low. If the column or row contains other values, specified in the Sort dialog box case sensitive.
such as Very Low or Extremely High, Excel places
those values at the bottom of the list so that the
order becomes High, Medium, Low, Extremely
High, and Very Low.

First, Second, Third, Fourth, Fifth

■ A list of current custom Á Click OK to close the Sort ■ Excel sorts the selected list
sort orders displays. Options dialog box. using the custom sort order.
ˇ Click the desired sort ‡ Click OK to close the Sort
order. dialog box.

35