Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
The below formula is already using absolute referencing and if dragged should
not change. =$A$2*$B$2 If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
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" wrote: The below formula is already using absolute referencing and if dragged should not change. =$A$2*$B$2 If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
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 ToolsOptions'Edit' tabCheck 'Allow cell drag and drop' If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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" wrote: The below formula is already using absolute referencing and if dragged should not change. =$A$2*$B$2 If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
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" wrote: 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 ToolsOptions'Edit' tabCheck 'Allow cell drag and drop' If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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" wrote: The below formula is already using absolute referencing and if dragged should not change. =$A$2*$B$2 If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
Try the below formula
=INDIRECT("A2")*INDIRECT("B2") If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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" wrote: 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 ToolsOptions'Edit' tabCheck 'Allow cell drag and drop' If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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" wrote: The below formula is already using absolute referencing and if dragged should not change. =$A$2*$B$2 If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed/Locked cell referencing
VERY NICE!! That works great! Thank you very much for your help.
"Jacob Skaria" wrote: Try the below formula =INDIRECT("A2")*INDIRECT("B2") If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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" wrote: 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 ToolsOptions'Edit' tabCheck 'Allow cell drag and drop' If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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" wrote: The below formula is already using absolute referencing and if dragged should not change. =$A$2*$B$2 If this post helps click Yes --------------- Jacob Skaria "tpdigg" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
locked cell not locked | Excel Discussion (Misc queries) | |||
how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |