Converting Cell References
You can go to the Edit Menu and select Replace. In the "Find What:" box,
enter $. In the "Replace With:" box, leave it blank. With the cells
highlighted in your sheet where you would like to remove the absolute
references, click replace all. It will remove all of the $.
"billbrandi" wrote:
Is there a quick way to convert fixed cell references ($row$column) to
eliminate the $ without editing the formula and deleting the $ one keystroke
at a time? Sure would save me a lot of time.
Thanks
Bill Falzone
|