Anchoring a cell.....

  • Thread starter Thread starter Heidi Lange
  • Start date Start date
H

Heidi Lange

I have a formula =c13 on cell E1.

I want to add a row and have cell E1 stay static with =c13

Help please!!
 
Hi Heidi,

Put "c13" in a cell (without the quotes), let's say in E2
Now in E1 use the formula =indirect(E2)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Thank you sooo much!!
-----Original Message-----
Hi Heidi,

Put "c13" in a cell (without the quotes), let's say in E2
Now in E1 use the formula =indirect(E2)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel




.
Click to expand...
 
Not if you add a row/column before C13 it won't - Try it ;-) The use of the $
signs make the reference absolute for the purposes of copying and pasting, but
inserting rows/columns prior to that cell will force it to move, and any linked
reference will stay with that cell, unless, you use INDIRECT.

See Niek's use of INDIRECT to lock down a reference that won't be affected by
inserting/deleting Rows/Columns in the other response.
 
You can also use it without having the data in another cell, eg:-

=INDIRECT("C13")
 

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

Multiply Cell Values which include text units 6
Changing Numerators but not Denominators 2
#DIV/0! error using Avgerage 15
Count only cells within Filtered Range 5
Excell formula. 4
I have a complex formula where I need to build in a MAX function 4
Formula using "lesser of" 3
Data Validation Lists Problem 3

Back
Top