Anchoring a cell.....

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!!
 
N

Niek Otten

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
 
H

Heidi Lange

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...
 
K

Ken Wright

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.
 
K

Ken Wright

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
#DIV/0! error using Avgerage 15
Changing Numerators but not Denominators 2
Count only cells within Filtered Range 5
Excell formula. 4
Formula using "lesser of" 3
I have a complex formula where I need to build in a MAX function 4
Data Validation Lists Problem 3

Top