Page 97 - IT-802_class_12
P. 97
Drag
The formula containing
the cell addresses
3.12.2 Absolute Referencing
Absolute referencing enables us to apply a formula in which the address of the cell does not change even if the formula
is applied to the new location of the cell. To apply an absolute cell reference, a $ (dollar) sign is added before the row
number and/or column name in the cell address (i.e., the $sign fixes the value).
To apply a formula by absolute referencing:
1 Type the formula in the original cell and put a $ sign before the row number and/or column ‘name of the address’.
2 Drag the Auto Fill Handle tool over the cell where the formula is to be applied.
[OR]
Right-click the mouse over the cell containing the formula and click on the Copy option.
3 Move to the new cell, right-click the mouse, and click on Paste.
For example, Let us assume that the formula applied in cell G3 is =C3+D3+E3+F3. Now to apply the same formula with the
value of the same cell, put the $ sign before Row and Column no. Now cell G3 contains formula =$C$3+$D$3+$E$3+$F$3.
After applied to another Cell G5, the addresses of the Cell, which form the expression do not change. The Formula in
Cell G5 will remain as it is, i.e., the formula as applied in G3.
Thus it displays the same result/data as displayed in G3.
The cell addresses
will not change
when the formula
is copied to
another cell
ICT Skills-IV 95

