Fixed/Locked cell referencing


T

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.
 
Ad

Advertisements

J

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
 
T

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.
 
J

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
 
T

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.
 
J

Jacob Skaria

Try the below formula

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

If this post helps click Yes
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top