data or formula. If you fill a relative formula, all the addresses of filled formulae will be changed. Chapter Drag Fill Handle Figure . Drag fill handle Cell pointer’s “Drag fill handle” is used to auto fill.
Just click and drag this handle to fill the contents. It can be dragged towards right or down. Same can be achieved by Edit → Fill → Down (or) Edit → Fill → Right. .
. Auto Fill Series: Auto Fill is also used to generate a series of values. For example, if you want to generate , , ……. up to some length; it can be done by a simple click and dragging over.
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 + 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. Chapter Time Unit: (Enabled