View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pritesh[_2_] Pritesh[_2_] is offline
external usenet poster
 
Posts: 26
Default How to remove the cell reference in a sheet at once

Stp1- Select range where you want to replace fixed references with relative
references.

Stp2- Press Ctrl + H, this will show Replace dialogue box.

Stp3- In "Find" space, type single $

Stp4- Leave "Replace" space empty

Stp5- Click "replace all".

You are done.. chk it.

Regards,
Pritesh


"The Greek" wrote:

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