791
Sorting Lists
To add a custom list to Excel, use either of the following procedures:
■ If the list is short, you can
type it directly into a dialog
box. Choose Tools, Options,
click the Custom Lists tab,
select New List, and start
entering items in the List
Entries box, as shown in
Figure 28.5. Be sure to enter
each item in the correct order,
and press Enter at the end of
each line. When the list is
complete, click the Add
button.
■ If the list is already available in
a worksheet, the process is
even easier. Say that you’ve cre-
ated a worksheet that contains all budget categories in the exact order that you want to
enter them every time. Open that sheet and ...