http://www.asap-utilities.com/downlo...-utilities.php
ASAP UTILITIES has a great add in for this under "formulas"( free download )
But you can also go to Find- Replace
e.g. =(F11-F6)/(F14*3)
Find : F
Replace with : $F$ etc
"clischak" wrote:
I have a block of cells with formulas. I want to change all of the cells
within the block to include $ in the formulas so that I can copy the block
and have each block identical.