Copying cells using absolute references
Posted by Dave on September 13, 2001 5:05 AM
Does anyone know if there is an easy way to copy and paste using absolute cell references without having to go through and change each formula to include dollar signs in each cell reference?
For example, if a cell contains formula '=C2' is there a way to copy this cell to another location a keep the contents of the cell as '=C2'? I realise putting dollar signs on the formula would achieve this but I do not want to do this as a have hundreds of cells to copy in this way.
As an alternative solution, is there a way to absolute-ize all cell references many cells at once?