Changing to absolute reference...

[ArcherSteve]

Well, I found a major design flaw in my excel workbook. I made all my references relative when I need them to be absolute (ooops..... ). Instead of clicking on every cell and changing it, is there a way to change all the references on a sheet to absolute at once (i.e. change =A1 to =$A$1)?


I've searched some forums and the MS Help assistant and no luck.


Thanks
Steve

 

[shades]

Howdy. The best way to do this is download ASAP Utilities. Then select your cells that need changing, and go to the ASAP menu and choose Formula > Change reference style.
________
Subaru srd-1

 

[ArcherSteve]

Thanks shades! Just what I was looking for!