| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A cell reference in a formula changing
How do I keep a cell reference in a formula from changing when a cell is
inserted above it? |
|
#2
|
|||
|
|||
|
You need to use the INDIRECT worksheet function. For example, to refer to
cell A1 no matter what is inserted above or to the left of the current cell A1: =INDIRECT("A1") HTH, Bernie MS Excel MVP "knemitz" wrote in message ... How do I keep a cell reference in a formula from changing when a cell is inserted above it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
| incrementing formula reference by 7 | Excel Discussion (Misc queries) | |||
| Formula to a Cell Reference | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| what is the formula for changing the same cell on different sheet. | Excel Worksheet Functions | |||
Linear Mode
