Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace$C$R references with Names

Status
Not open for further replies.

NIWANut

Programmer
May 20, 2003
25
NZ
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
 
Try using the menu command Insert/Names/Apply.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top