excel - mr.frankie

  • Thread starter Thread starter zachary85
  • Start date Start date
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
 
what is the difference between relative and absolute addressing?
Click to expand...

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
 
Fourth time posted - each time under a different name.


what is the difference between relative and absolute addressing?
 
Press F1, plug in "relative references", click the first link, and read
all about them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what is the difference between relative and absolute addressing 2
google newsgroup 3
help me please 3
Excel 2010 1
Need help using a relative path in VBA 0
Can't Explain N/A in Vlookup 2
Mixed references 2
I've a problem~ 1

Back
Top