Microsoft Formula Help

February 5, 2007 7:53 PM

How do I cut/paste a project in MS Excel and not have my formula cells change with the movement of my cells?

I created a formula that I use to get the present value on oil/gas wells. I made it so that I can change a number of variables easily and the whole present value formula will change. My issue is that; for example, I get my price number from a formula answer on worksheet 2 in cell B1. In worksheet 1 I have a formula that calls to worksheet2 cell B1.

How do I autofill or whatever dragging the bottom right corner of the cell with out excel automatically thinking I want to reference worksheet 2 cell B2. I always want that formula to go to cell B1.

God that sounds confusing, If you don't follow I can break it down more if you need me to.

posted by mi6op to computers & internet (4 comments total)

You need to use absolute addressing in your formula.

http://www.awardsites.com/tutorials/excel/cell_ref-01.htm
posted by matholio at 8:02 PM on February 5, 2007

Put $ in front of anything you want to keep constant.
posted by pinksoftsoap at 8:21 PM on February 5, 2007

Hitting the F4 key toggles through all of the variations on placing the $.
posted by grateful at 7:24 AM on February 6, 2007

Hitting the F1 key opens the extremely comprehensive application help file.
posted by stavrosthewonderchicken at 4:24 PM on February 6, 2007