Microsoft Office Tutorials and References
In Depth Information
Chapter 1: AutoFill
FIGURE 1.1 Using the Drag Handle
You may want to try it yourself. As shown in Figure 1.6, all of the columns
selected are highlighted and the crosshair handle appears at the lower right corner
of the final column. In Figure 1.7, you can see the results after using the AutoFill
More features of the AutoFill function are discussed in the context of regressions
in Chapter 12. I also explain the concept of Time in Excel in Chapter 12.
Creating Custom Lists in Excel enables you to use these lists as demonstrated
with the AutoFill function. Custom Lists let you use them when you sort in Excel. In
addition to sorting in numerical or alphanumeric order, you can also sort with these
Custom Lists or with the ones you create. You can use the list created here later to
sort a database.
To create a Custom List in Excel, you need to type the list in a range on a sheet
as shown in Figure 1.8. I used a list of the 10 largest cities in the United States where
your company may be doing business as an example.
Refer to Figure 1.2 for how to access the Custom Lists menu. In Excel 2010, go
to the File icon to get to the Excel Advanced Options menu and the Custom Lists
menu. For Excel 2007, go to the Office icon, click on Excel Options, and click on
the Edit Custom Lists button. The result is shown in Figure 1.9. For Excel 2003
or the Mac 2011 version, see the Appendix to this chapter.
Now all you have to do to make the list of the 10 largest cities in the United
States, sorted by population size, part of your Excel Custom List, is click on
the empty cell on the menu to the left of the Import button and select the cells on the
sheet. Click on the Import button and the list is now part of your Custom Lists. See