View Single Post
  #4   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by The Greek View Post
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???

select the content and use Cltr + H (find and replace for $).

note: please make sure it effect only selected cells not the entire spreadsheet.

all the best
__________________
Thanks
Bala