batch convert relative to absolute

R

rygo

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a large group of cells containing formulae with relative cell references (about 300 cells total).

I need to change all of these to absolute cell references.

I could spend hours and CMD+T each one individually. But is there a way to do them as a batch? ie select a whole range and convert all at the same time.

Thanks in advance
 
H

Harvey Waxman

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a large group of cells containing formulae with relative cell
references (about 300 cells total).

I need to change all of these to absolute cell references.

I could spend hours and CMD+T each one individually. But is there a way to do
them as a batch? ie select a whole range and convert all at the same time.

Thanks in advance
Click to expand...

Find and Replace in formulas only?
 
R

rygo

Thanks for that, had to do each column separately but worked well.

Feeling like a numwit now!
 
Top