QuickLearn
09-02-2002, 04:36 PM
CREATING A CUSTOM AUTOFILL SERIES IN EXCEL
This tip can save you a lot of time when building a worksheet.
Excel ships with certain commonly-used series programmed into its AutoFill feature and allows you to add to this list through the "Custom Lists" tab in the "Options" dialogue box ("Tools" menu). But you can also create a custom series by providing Excel with an example it can follow in creating the series. Here is how you do it:
-- Enter the first two series values in adjoining cells. For example, to create a series of integers beginning with 5 and increasing by 5 each time enter 5 and 10.
-- Select (highlight) the two sample cells.
-- Place the mouse on the "fill handle" in the lower right corner of the selected area.
-- Drag the mouse across the cells into which you want the series to be entered. In our example those cells would be filled with 15, 20, 25, etc.
Roger Younce
QuickLearn Computer Training Services
http://quicklearncomputertraining.com
This tip can save you a lot of time when building a worksheet.
Excel ships with certain commonly-used series programmed into its AutoFill feature and allows you to add to this list through the "Custom Lists" tab in the "Options" dialogue box ("Tools" menu). But you can also create a custom series by providing Excel with an example it can follow in creating the series. Here is how you do it:
-- Enter the first two series values in adjoining cells. For example, to create a series of integers beginning with 5 and increasing by 5 each time enter 5 and 10.
-- Select (highlight) the two sample cells.
-- Place the mouse on the "fill handle" in the lower right corner of the selected area.
-- Drag the mouse across the cells into which you want the series to be entered. In our example those cells would be filled with 15, 20, 25, etc.
Roger Younce
QuickLearn Computer Training Services
http://quicklearncomputertraining.com