Page 47 - Excel Data Analysis

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

ORGANIZE WORKSHEET DATA 2

Instead of manually typing a list to use for your sort, you
can import a list of data values from any open worksheet.
You can do so by using the Import List From Cells field in
the Custom Lists tab. You can either manually type the
range of cells containing your list, or select the range of
cells containing the list within a worksheet.
To select the range of cells, click the Collapse Dialog button
( ) to reduce the size of the Options dialog box. Locate
the worksheet containing the sort order values and select
the corresponding cells. The selected range of cells displays
in the field. Next, click the Restore Dialog button ( ) to
restore the Options dialog box back to the original size.
See Chapter 1 for more information on selecting a range
of cells.
Click the Import button in the Custom Lists tab, and Excel
adds the values from the selected range of cells to the List
Entries box. The values appear in the list in the order they
appear in the selected cells. You can make any desired
modifications to the list by typing or deleting values. Finally,
click Add to create the sort order. For a clearer picture of
how to work the Collapse Dialog and the Restore Dialog
buttons, see the section "Consolidate Data."

NEW LIST

First, Second, Third, Fourth, Fif

‹ Click NEW LIST in the ˇ When you complete the ■ Excel adds the sort order Á Click OK to close the
Custom Lists box. list, click Add. list to the Custom lists box. Options dialog box.
› Type the order in which
you want to sort your list, CONTINUED
pressing Enter after each
list item. 33