View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Greek The Greek is offline
external usenet poster
 
Posts: 14
Default How to remove the cell reference in a sheet at once

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???