Page 281 - Computer - 9(A&B)
P. 281
Copying Formula using AutoFill
If you wish to apply the same formula to number of cells in the rows or columns, you Rapid Fireapid Fire
R
need not enter the formula again and again in each cell. A formula can be copied. Can you fill an odd
It saves time and efforts in the case of long and complex formulae and reduces the number series using the
chances of errors. You can quickly copy formulas into document cells by using the Autofill feature in Calc?
Fill the handle. When you drag the handle to other cells, Calc will show different
result for each cell.
To copy a formula:
Step 1: Select the cell that contains the formula you want to fi ll into adjacent cells.
Step 2: Rest your cursor in the lower-right corner so that it turns into a plus sign (+).
Step 3: Drag the Fill handle down, up, or across the cells that you want to fi ll.
The formula gets automatically copied to the other cells.
143
143