Microsoft Office Tutorials and References
In Depth Information
Automatically Filling a Range with a Series
line). Then click the Add button to create the list. Figure 35-4 shows a custom list of region
names that use Roman numerals.
Figure 35-4: These region names work with the Excel Autofill feature.
For more control over what happens when using Autofill, use the right mouse button to click and
drag the fill handle. When you release the button, you see a shortcut menu with some options (see
Figure 35-5). The items that are available on the shortcut menu depend on the type of data selected.
For example, if the first cell in the series contains a date, the date-related options are enabled.
Figure 35-5: The shortcut menu for Autofill.
Search JabSto ::

Custom Search