How to remove the cell reference in a sheet at once
With formulas like =$A$1+$B$1 and pulled down for 30 cells, I used Edit
Find $ replace with "nothing" OK
HTH
Regards,
Howard
"The Greek" wrote in message
...
Hi,
I have a sheet where there are many cells are fix (reference cells)
using the F4 key. Is there any way i can remove the effect of the F4
without going to each formula and them keep pressing F4 to remove the
reference???
|