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