C
cj
What does a $ in a cell do?
Example ($A1)
Example ($A1)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Go to help and type in absolute
then look for cell references
then look for cell references
R
Ragdyer
J
John
It makes the row, column or the complete cell absolute. This means when you
use the fill handle to duplicate formulas the part or all the cell reference
does not change. ie =$A1 in a cell and fill it down it changes to =$a2, =$A3
etc, but a fill it across the sheet and the 'A' does not change so all you
get is =$A1. To make the cell completly absolute then use $a$1
hope this helps
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)
use the fill handle to duplicate formulas the part or all the cell reference
does not change. ie =$A1 in a cell and fill it down it changes to =$a2, =$A3
etc, but a fill it across the sheet and the 'A' does not change so all you
get is =$A1. To make the cell completly absolute then use $a$1
hope this helps
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)
C
challa prabhu
Hi,
$ in a cell refers to Absolute reference and not relative reference. The
pointer to the cell value remains constant.
For example: It is like Pointer to an address in arrays in C programming. In
relative refernce the value will change based on the changing reference.
Note: You can use also use named definition as pointer to address. The named
definition will be store the absolute address of the cell or range of cells
as reference.
Challa Prabhu
$ in a cell refers to Absolute reference and not relative reference. The
pointer to the cell value remains constant.
For example: It is like Pointer to an address in arrays in C programming. In
relative refernce the value will change based on the changing reference.
Note: You can use also use named definition as pointer to address. The named
definition will be store the absolute address of the cell or range of cells
as reference.
Challa Prabhu