| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
| I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
| how do i reference cells to create a chart? | Charts and Charting in Excel | |||
| 3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Linear Mode
