Fixed/Locked cell referencing

[tpdigg]

I am creating a spreadsheet that will be used to drag and drop and move
information around in but my cell referncing changes when data in a
referenced cell is dragged to another cell. Is it possible to create cell
references in formula's that do NOT change when the data in a referenced cell
is dragged?

For example:
- Desired Formula in Cell C2 "=($A$2*$B$2)"
- if I drag cell A2 to cell A3 my formula in cell C2 automatically changes
to ($A$3*$B$2). Is there a way to stop that from changing?

Thank you for you help.

 

[Jacob Skaria]

The below formula is already using absolute referencing and if dragged should
not change.

=$A$2*$B$2

If this post helps click Yes

 

[tpdigg]

thanks for the reply Jacob.

That works if I am copying the formula to another cell or if I drag the cell
with the formula but not if I drag a referenced cell (cell A2 or cell B2).
If I drag either of the referenced cells the formula changes.

 

[Jacob Skaria]

I think you are moving the cell. Please make sure you are dragging the cell
and not moving the cell..

(Drag using the handle at the right bottom of the cell; where the cursor
turns to a + sign) . If you dont see that check out from menu
Tools>Options>'Edit' tab>Check 'Allow cell drag and drop'

If this post helps click Yes

 

[tpdigg]

I tried that. The "+" sign indicates a copying function from one cell to the
next. I don't want to copy data in the referenced cell, I want to drag the
information around the spreadsheet. If that is "moving the cell" then that
is what I want to do but I want to "move" the referenced cell (A2 and B2)
without changing the formula (in cell C2).

I get the feeling I am not explaining myself very well.

Thanks for trying Jacob.

 

[Jacob Skaria]

Try the below formula

=INDIRECT("A2")*INDIRECT("B2")

If this post helps click Yes

 

[tpdigg]

VERY NICE!! That works great! Thank you very much for your help.