Unit 9: Moving Data

MOVING OR COPYING FORMULA:

When you move a formula from one cell to another, the cell reference within the formula do not change. But when you copy formula, then

  • Absolute cell references do not change.

  • Relative cell references will change when you copy a formula.

TO MOVE OR COPY A FORMULA, DO THIS:

    1. Select the cell that contains the formula you want to move.

    2. Point to the border of the selection.

    3. To move the cell, drag the selection to the upper-left cell of the paste area. Excel replaces any existing data in the pasted area.

    4. To copy the cell, hold down CTRL keys as you drag the mouse.

You can also copy formulas into adjacent cells by using the fill handle. Select the cell that contains the formula and then drag the fill handle over the range you want to fill.

ENTERING CELL REFERENCES:

Cell references allow you to use values from different parts of a worksheet and execute and enables you to do the desired calculation. You can use any cell or group of cells in a formula. The reference of the active cell is displayed in the name box at the left end of the formula bar.

UNIT 9 – Moving Data


There aren't any posts currently published in this category.