abc MICROSOFT EXCEL 2010 - Formulas
Absolute address 01 (COPY)

When copying cells ,the address in the formula changes as well. When the user doesn't want the adress to change they use an absolute address.The indicator of the absoulte address is a $ in front of the letter and number in the address of the cell. Then, the address doesn't change when copying or moving cells. Relative address 01 (COPY).

  1.    Copying a formula using a fill handle A1 1
  2.    Copying a formula using a fill handle A$1 2
  3.    Copying a formula using a fill handle $A1 3
  4.    Copying a formula using a fill handle $A$1 4
  5.    Copying a formula using a fill handle horizontalno 5
  6.    Copying a formula using a fill handle vertikalno 6

Absolute address 01 (COPY), steps:

  1. Pick a cell with the expression (B2)
  2. EDIT, COPY, (B2) = $B$1 + $C$1;
  3. Type + ;
  4. Click on a different cell (D2);
  5. EDIT, PASTE = $B$1 + $C$1;
  6. End.

 Index