D
ducksfolly
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?
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?