Hi,
I have a spreadsheet that has many formula and decided it was better to name the cells used in those formulas with meaningful names. Presently they are in $C$R format.
So having named the appropriate cells, I now want to change all the formula references from $C$R type to my Names.
Is there a quick way to do this globally (there are heaps of them) or do I have to edit each formula manually?
George
I have a spreadsheet that has many formula and decided it was better to name the cells used in those formulas with meaningful names. Presently they are in $C$R format.
So having named the appropriate cells, I now want to change all the formula references from $C$R type to my Names.
Is there a quick way to do this globally (there are heaps of them) or do I have to edit each formula manually?
George