How Do You ANCHOR a Cell Reference?
 

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.

--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites

How Do You ANCHOR a Cell Reference?
 

What are you seeking? if $D$12 doesn't do it and the relative reference D12
doesnt' do it either?

Tyro

"Berkeley Brett" 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.

--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites

How Do You ANCHOR a Cell Reference?
 

Change the formula in cell A3 to =$D$12.



"Berkeley Brett" 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.

--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites

How Do You ANCHOR a Cell Reference?
 

=INDIRECT("D12")

--
Tim Zych
SF, CA

"Berkeley Brett" 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.

--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites

How Do You ANCHOR a Cell Reference?
 

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



"Berkeley Brett"

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.
--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites

How Do You ANCHOR a Cell Reference?
 

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!

--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites