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!!
I want to add a row and have cell E1 stay static with =c13
Help please!!
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.
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
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
D
Dianne
Change your formula to =$c$13 - the dollar signs will anchor your cell.
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
.
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.
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")
=INDIRECT("C13")