Z
zachary85
what is the difference between relative and absolute addressing?
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.
B
Bob Umlas
Relative address is relative to the active cell. If in cell A1 you have =B2,
you REALLY have a reference to one cell down and one to the right. So if you
were to copy cell A1 with that formula and paste it to cell H77, you'd see
=I78 which is still one cell down & one to the right. However, if cell A1
contained an absolute address like =$B$2, this refers to cell B2. If you
copy cell A1 to H77, you'd see =$B$2.
HTH
Bob Umlas
Excel MVP
you REALLY have a reference to one cell down and one to the right. So if you
were to copy cell A1 with that formula and paste it to cell H77, you'd see
=I78 which is still one cell down & one to the right. However, if cell A1
contained an absolute address like =$B$2, this refers to cell B2. If you
copy cell A1 to H77, you'd see =$B$2.
HTH
Bob Umlas
Excel MVP
A
Andy
what is the difference between relative and absolute addressing?
Absolute addressing
101 Any Street
Anytown
California.
Cell D17
Relative addressing
The house three to the left of this one
Two cells to the left and one up from this one R[-1]C[-2]
Andy
J
Jim Cone
Fourth time posted - each time under a different name.
what is the difference between relative and absolute addressing?
what is the difference between relative and absolute addressing?
B
Bob I
Press F1, plug in "relative references", click the first link, and read
all about them.
all about them.