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
   276   277   278   279   280   281   282   283   284   285   286