How Do You ANCHOR a Cell Reference?

B

Berkeley Brett

Suppose I set one cell equal to another -- say, in cell A3, I put

=D12

Now, cell A3 will be set equal to whatever is in D12, with whatever
formatting adjustments there may be.

Now here's my problem....

If I INSERT a cell ABOVE D12, pushing the contents of D12 down to cell
D13, Excel adjusts the formula in cell A3 to

=D13

Excel changes the formula in an attempt to help me out. Often enough,
this is a helpful thing. But sometimes it isn't!

What if I want cell A3 to be set equal to whatever is in the EXACT
cell D12, regardless of whether any cells have been inserted above
it? Is there a way to anchor the reference to EXACTLY a specific
cell?

Thanks in advance for any help you may have!

P.S.

=$D$12 isn't what I'm looking for. That anchors in a different way,
not the way I'm seeking.
 
J

Jim Cone

Maybe you want...
=INDIRECT("D12")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Berkeley Brett"
<[email protected]>
wrote in message
Suppose I set one cell equal to another -- say, in cell A3, I put
=D12
Now, cell A3 will be set equal to whatever is in D12, with whatever
formatting adjustments there may be.
Now here's my problem....
If I INSERT a cell ABOVE D12, pushing the contents of D12 down to cell
D13, Excel adjusts the formula in cell A3 to
=D13
Excel changes the formula in an attempt to help me out. Often enough,
this is a helpful thing. But sometimes it isn't!
What if I want cell A3 to be set equal to whatever is in the EXACT
cell D12, regardless of whether any cells have been inserted above
it? Is there a way to anchor the reference to EXACTLY a specific
cell?
Thanks in advance for any help you may have!

P.S.
=$D$12 isn't what I'm looking for. That anchors in a different way,
not the way I'm seeking.
 
B

Berkeley Brett

Thank you, Tyro, Bob, Tim, and Jim.

Tim and Jim nailed it! That's exactly what I was looking for!

=INDIRECT("D12")

does the trick!

Much thanks to all!
 

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

Anchor issue with inserting a shape for letterhead 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
ARE ALL THE CELLS EQUAL? 8
HOW TO COUNT INSIDE A CELL 5
Auto/conditional format 0
How to synchronize all cell values? 1
Stumped on adding 3 cells 2
copy conditional formulas that reference one cell 2

Top