Change block of cell referances to absolute (F4)

[eugene7]

I have a large (very) range of cells that are presently referencing other cell values cells relatively - I need to convert them to absolute reference (the F4 command) but there are too many to do individually...

I tried to make a macro, but cant make it work.

The cells I need to change are in columns. Any ideas?

Steve

 

[ken2step]

You could go and download the free add-in ASAP Utilities and this feature is included that changes references in formulas.
http://www.asap-utilities.com/

 

[SteveO59L]

Do all your releative formulas in one column, reference the same column ?

 

[eugene7]

Thanks for the free download suggestion, and yes they do all referance the same column from a single column...

Steve