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.....:o ). 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

Howdy. The best way to do this is download ASAP Utilities (http://www.asap-utilities.com/). Then select your cells that need changing, and go to the ASAP menu and choose Formula > Change reference style.

Thanks shades! Just what I was looking for!