Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How Do You ANCHOR a Cell Reference?

16,904 views
Skip to first unread message

Berkeley Brett

unread,
Jan 21, 2008, 9:29:39 PM1/21/08
to
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

Tyro

unread,
Jan 21, 2008, 9:52:59 PM1/21/08
to
What are you seeking? if $D$12 doesn't do it and the relative reference D12
doesnt' do it either?

Tyro

"Berkeley Brett" <Roya...@gmail.com> wrote in message
news:ca303e61-7314-42d4...@s13g2000prd.googlegroups.com...

Bob

unread,
Jan 21, 2008, 10:29:50 PM1/21/08
to
Change the formula in cell A3 to =$D$12.

"Berkeley Brett" <Roya...@gmail.com> wrote in message
news:ca303e61-7314-42d4...@s13g2000prd.googlegroups.com...

Tim Zych

unread,
Jan 21, 2008, 10:53:02 PM1/21/08
to
=INDIRECT("D12")

--
Tim Zych
SF, CA

"Berkeley Brett" <Roya...@gmail.com> wrote in message
news:ca303e61-7314-42d4...@s13g2000prd.googlegroups.com...

Jim Cone

unread,
Jan 21, 2008, 10:54:33 PM1/21/08
to

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

"Berkeley Brett"
<Roya...@gmail.com>
wrote in message

Berkeley Brett

unread,
Jan 22, 2008, 1:57:36 PM1/22/08
to
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!

0 new messages