Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
If you are referencing a cell in a formula and you want it to remain the same
when you copy and paste the formula into another cell, how do you enter it? Susan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
Susan,
use the dollar sign =$a$1 Mike "Susan" wrote: If you are referencing a cell in a formula and you want it to remain the same when you copy and paste the formula into another cell, how do you enter it? Susan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
$A$1
See help for more on relative and absolute references. Gord Dibben MS Excel MVP \On Thu, 5 Jul 2007 11:00:02 -0700, Susan wrote: If you are referencing a cell in a formula and you want it to remain the same when you copy and paste the formula into another cell, how do you enter it? Susan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
This was never a problem in Excel 2003. I am trying to copy and paste a row
in new rows I have inserted. I have tried relative references, but then the formula in the cell I copied remain the same. The self help section for this says that if a formula is copied and pasted the relationship will not change, but it does. Here is my formula: =SUM((B138-B137)/G138) I used this to automatically figure my gas mileage and ran out of rows, so I need to insert rows with the same formulas across the row. When I copy the row, the formula changes to this for the copied cell =SUM((B138-B136)/G138). None of this ever happened with Excel 2003. I could create new rows, copy and paste the formulas and the reference would remain the same. "Gord Dibben" wrote: $A$1 See help for more on relative and absolute references. Gord Dibben MS Excel MVP \On Thu, 5 Jul 2007 11:00:02 -0700, Susan wrote: If you are referencing a cell in a formula and you want it to remain the same when you copy and paste the formula into another cell, how do you enter it? Susan |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
You were using Excel 2003. What version are you using now? If it's Excel
2007, it works the same as Excel 2003 in regards to addresses. Tyro "Larry" wrote in message ... This was never a problem in Excel 2003. I am trying to copy and paste a row in new rows I have inserted. I have tried relative references, but then the formula in the cell I copied remain the same. The self help section for this says that if a formula is copied and pasted the relationship will not change, but it does. Here is my formula: =SUM((B138-B137)/G138) I used this to automatically figure my gas mileage and ran out of rows, so I need to insert rows with the same formulas across the row. When I copy the row, the formula changes to this for the copied cell =SUM((B138-B136)/G138). None of this ever happened with Excel 2003. I could create new rows, copy and paste the formulas and the reference would remain the same. "Gord Dibben" wrote: $A$1 See help for more on relative and absolute references. Gord Dibben MS Excel MVP \On Thu, 5 Jul 2007 11:00:02 -0700, Susan wrote: If you are referencing a cell in a formula and you want it to remain the same when you copy and paste the formula into another cell, how do you enter it? Susan |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
Hi Larry
Try this: =SUM(($B$138-$B$136)-$G$138) HTH Cimjet "Larry" wrote in message ... This was never a problem in Excel 2003. I am trying to copy and paste a row in new rows I have inserted. I have tried relative references, but then the formula in the cell I copied remain the same. The self help section for this says that if a formula is copied and pasted the relationship will not change, but it does. Here is my formula: =SUM((B138-B137)/G138) I used this to automatically figure my gas mileage and ran out of rows, so I need to insert rows with the same formulas across the row. When I copy the row, the formula changes to this for the copied cell =SUM((B138-B136)/G138). None of this ever happened with Excel 2003. I could create new rows, copy and paste the formulas and the reference would remain the same. "Gord Dibben" wrote: $A$1 See help for more on relative and absolute references. Gord Dibben MS Excel MVP \On Thu, 5 Jul 2007 11:00:02 -0700, Susan wrote: If you are referencing a cell in a formula and you want it to remain the same when you copy and paste the formula into another cell, how do you enter it? Susan |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep Same Cell Reference
I have to use the paste formula function and that appears to work. Can't do
just paste. I am serious. I did Ctrl-C and Ctrl-V in 2003 and everything was good. Using 2007 now. "Cimjet" wrote: Hi Larry Try this: =SUM(($B$138-$B$136)-$G$138) HTH Cimjet "Larry" wrote in message ... This was never a problem in Excel 2003. I am trying to copy and paste a row in new rows I have inserted. I have tried relative references, but then the formula in the cell I copied remain the same. The self help section for this says that if a formula is copied and pasted the relationship will not change, but it does. Here is my formula: =SUM((B138-B137)/G138) I used this to automatically figure my gas mileage and ran out of rows, so I need to insert rows with the same formulas across the row. When I copy the row, the formula changes to this for the copied cell =SUM((B138-B136)/G138). None of this ever happened with Excel 2003. I could create new rows, copy and paste the formulas and the reference would remain the same. "Gord Dibben" wrote: $A$1 See help for more on relative and absolute references. Gord Dibben MS Excel MVP \On Thu, 5 Jul 2007 11:00:02 -0700, Susan wrote: If you are referencing a cell in a formula and you want it to remain the same when you copy and paste the formula into another cell, how do you enter it? Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |