Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you have fixed cell reference when dragging/copying formulae?
When you drag or copy a formula which refers to another cell, then that
cell's reference is updated when the formula is dragged or copied across a spreadsheet. Is it possible to 'fix' the reference of the outside cell such that the formula refers to a fixed cell irrespective of where the formula is copied to? For example a formual in cell B2 containing a reference to cell A1 will always refer to the cell immediately above and to the left when copied elsewhere. Is it possible for the formula to be forced to refer to cell A1 irrespective of where it is copied? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you have fixed cell reference when dragging/copying formulae?
You can use $a$1 in the formula.
If you use a $ in front of the row or column, then that portion of the address won't change when you copy the formula. $a1 would allow the row number to change a$1 would allow the column to change a1 would allow both to change $a$1 wouldn't change. Look at excel's help for Absolute and relative references. ducksfolly wrote: When you drag or copy a formula which refers to another cell, then that cell's reference is updated when the formula is dragged or copied across a spreadsheet. Is it possible to 'fix' the reference of the outside cell such that the formula refers to a fixed cell irrespective of where the formula is copied to? For example a formual in cell B2 containing a reference to cell A1 will always refer to the cell immediately above and to the left when copied elsewhere. Is it possible for the formula to be forced to refer to cell A1 irrespective of where it is copied? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you have fixed cell reference when dragging/copying formulae?
Hi
Have a look for 'absolute and relative' cell references. You use the $ sign to indicate which part of the reference stays static. In your example, you'd use =$A$1 and this would then stay the same wherever it was copied. Andy. "ducksfolly" wrote in message ... When you drag or copy a formula which refers to another cell, then that cell's reference is updated when the formula is dragged or copied across a spreadsheet. Is it possible to 'fix' the reference of the outside cell such that the formula refers to a fixed cell irrespective of where the formula is copied to? For example a formual in cell B2 containing a reference to cell A1 will always refer to the cell immediately above and to the left when copied elsewhere. Is it possible for the formula to be forced to refer to cell A1 irrespective of where it is copied? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you have fixed cell reference when dragging/copying formul
Dave
Thank you very much for that. I had a feeling it would be bleeding obvious! Anthony Goddard "Dave Peterson" wrote: You can use $a$1 in the formula. If you use a $ in front of the row or column, then that portion of the address won't change when you copy the formula. $a1 would allow the row number to change a$1 would allow the column to change a1 would allow both to change $a$1 wouldn't change. Look at excel's help for Absolute and relative references. ducksfolly wrote: When you drag or copy a formula which refers to another cell, then that cell's reference is updated when the formula is dragged or copied across a spreadsheet. Is it possible to 'fix' the reference of the outside cell such that the formula refers to a fixed cell irrespective of where the formula is copied to? For example a formual in cell B2 containing a reference to cell A1 will always refer to the cell immediately above and to the left when copied elsewhere. Is it possible for the formula to be forced to refer to cell A1 irrespective of where it is copied? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you have fixed cell reference when dragging/copying formul
Andy
Thank you very much for that. I had a feeling it would be bleeding obvious! Anthony Goddard "Andy" wrote: Hi Have a look for 'absolute and relative' cell references. You use the $ sign to indicate which part of the reference stays static. In your example, you'd use =$A$1 and this would then stay the same wherever it was copied. Andy. "ducksfolly" wrote in message ... When you drag or copy a formula which refers to another cell, then that cell's reference is updated when the formula is dragged or copied across a spreadsheet. Is it possible to 'fix' the reference of the outside cell such that the formula refers to a fixed cell irrespective of where the formula is copied to? For example a formual in cell B2 containing a reference to cell A1 will always refer to the cell immediately above and to the left when copied elsewhere. Is it possible for the formula to be forced to refer to cell A1 irrespective of where it is copied? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |