View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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???