CELL REFERENCING

Cell referencing

Excel is dynamic when it comes to cell addresses. If you have a cell with a formula that references a different cell’s address and you copy the formula from the first cell to another cell, Excel updates the cell reference inside the formula. Try an example:

     1.      In cell B2, enter 100.

     2.      In cell C2, enter =B2*2.

     3 .      Press Enter.

     4.      Cell C2 now returns the value 200.

     5.      If C2 is not the active cell, click it once.

     6.      Press Ctrl+C, or click the Copy button on the Home tab.

     7.      Click cell C3.

8.      Press Ctrl+V, or click the Paste button on the Home tab