For example, say I have a spreadsheet with the following:
In A1, I have the formula =$b$1+$c$1. B1 has 2 and C1 has 3. A1 correctly displays 5. But if I drag B1, the formula changes to reflect the new location of B1, and A1 still shows 5. What I want is for the formula to always stay $b$1+$c$1, regardless of what I do with the values in B1 and C1.
I suspect (hope) that this is something easy that I’ve just forgotten how to do. Help!
Thanks in advance.
In Excel, How Do I Make A Formula Always Point To A Cell, Even If I Move The Content?
By WinPie Posted in: excel
Leave a Reply
You must be logged in to post a comment.
See More Infomations
New Articles in Category6
- I Know How To Normally Print From Excel But I Have A Doc I Can’t Save (overtop Someone Else’s Doc)?
- Excel Macro Help Pleasee!!!?
- Excel – Merging Workbooks. Please Help?
- How Do You Calculate The Standard Deviation Of This?
- In Excel, How To Tally Calls Over 2 Minutes, Under 2 Minutes In A List?
- Can Asians Do Everything Perfectly Or What?
More Interesting Things
©2011 Windows Pie, All rights reserved.
use the INDIRECT() function to turn B1 into a “text string”
so
=INDIRECT(“B1″)+$C$1
then you can drag B1 around and the formula wont change
I’m having trouble understanding your question. You say “the formula changes” but then you say that A1 still shows 5! It still shows 5, because it still equals B1+C1. Dragging B1 doesn’t alter the original contents of B1, it just copies B1 to another cell. B1 is still 2. If you change B1 or C1, A1 will change.