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