also used to generate a series of values. For example, if you want to generate , , ……. up to some value; it can be done by a simple clicking and drag process. Generating whole number series: (Refer Figure .
). Step : In cell A1, type as (one) and press enter Step : Click A1 to place the cell pointer Step : Click “Drag Fill Handle” of cell pointer; now the mouse pointer becomes a small + sign Step : Drag over the cells; while dragging, the generated values will be displayed. Step : Release the mouse pointer. Selected cells will be filled with series of values.
Drag fill handle Drag Cells Generated series Figure . AutoFill series . . Generating series using command Edit → Fill → Series Command is used to generate different set of series.
Before using this feature, a set of cells should be selected. Using Fill Series feature, you can fill series of values at any direction. (Remember that, auto fill only fills either right or down). Refer Figure .
. Direction : Down / Right / Up / Left (Selected cell direction will be default) Series type : Linear : To generate a sequence of series (Example , , , , …….) Growth : To generate multiplication series (Example , , , , , ……) Date : To generate date series (when you select date as series type; time unit section gets enabled) AutoFill : To generate a continuous series of values ( , , ,…….). When you select “AutoFill”, Time unit section, End value and Increment text boxes become disabled. Time Unit: (Enabled only when you select the series type as “Date”) Day : To generate date series day-wise Weekday : To generate date series weekday-wise Month : To generate date series month-wise Year : To generate date series year-wise Start Value: Initial value of the series should be typed End Value: End value of the series should be typed If you fail to specify the end value, series will be generated upto the selected cells.
Figure . Fill series dialog box If your selection is less than the specified