Use Edit Find

Find the dollar sign and replace with nothing
--
Gary's Student


"Castor" wrote:

Hi,

I have a worksheet filled with cells that contain formulas with $ signs i.e.
reference to particular cells.

Is it possible to select all cells and remove the absolute reference at one
shot, instead of manually fixing each formula in each cell? Tks a lot! -
Castor