Z
zafer ozer
What is the difference between A1 and $A$1
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.
J
John
Hi
It's relative and absolute.
For a full explanation press F1 and type relative, you will get the explanation
you want.
HTH
John
It's relative and absolute.
For a full explanation press F1 and type relative, you will get the explanation
you want.
HTH
John
G
Gary''s Student
If you copy
=A1 to another cell it will adjust
if you copy
=$A$1 to another cell it will not adjust
=A1 to another cell it will adjust
if you copy
=$A$1 to another cell it will not adjust
C
cm
the dollar signs indicate an 'absolute' cell reference. - one $ for the
column and one $ for the row. If this cell is referenced elsewhere in the
spreadsheet as A1 and the formula is copied, the cell reference will change.
If it is absolute, ($A$1), the formula referening it can be copied anywhere
and the reference to A1 stays the same.
column and one $ for the row. If this cell is referenced elsewhere in the
spreadsheet as A1 and the formula is copied, the cell reference will change.
If it is absolute, ($A$1), the formula referening it can be copied anywhere
and the reference to A1 stays the same.
L
L. Howard Kittle
And with your cell reference in the edit mode, hit F4 to toggle through the
four reference modes available. When you have the one you want, hit Enter
HTH
Regards,
Howard
four reference modes available. When you have the one you want, hit Enter
HTH
Regards,
Howard