| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
troubleshoot absolute value
I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g.
from A3) and for that cell (A19) to maintain the same value from A3 after adding another row above A3. I've put in $A$3 in cell A19, but once I add a row above the third row, the now A20 automatically changes to ($A$4). How do I keep the absolute value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making multiple cells absolute at once | Excel Discussion (Misc queries) | |||
| replace absolute references | Excel Worksheet Functions | |||
| replace absolute references | Excel Worksheet Functions | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
| Trouble with making a 3D reference absolute | Excel Discussion (Misc queries) | |||
Threaded Mode
