ExcelBanter - Removing $$ Reference in cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Removing $$ Reference in cells (https://www.excelbanter.com/excel-worksheet-functions/40260-removing-%24%24-reference-cells.html)

Castor

Removing $$ Reference in cells

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

Gary's Student

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

All times are GMT +1. The time now is 11:40 AM.