| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking formula cell references
I have a cell that references B2 i need the reference to stay at B2 even if i insert a row at row 2. Currently the reference moves to B3. Is there any way around this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
locking formula cell references
You must reference B$2
HTH -- AP "Superchikn" a écrit dans le message de ... I have a cell that references B2 i need the reference to stay at B2 even if i insert a row at row 2. Currently the reference moves to B3. Is there any way around this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
locking formula cell references
Tried that already....Cell reference changes to B$3
"Ardus Petus" wrote: You must reference B$2 HTH -- AP "Superchikn" a écrit dans le message de ... I have a cell that references B2 i need the reference to stay at B2 even if i insert a row at row 2. Currently the reference moves to B3. Is there any way around this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
locking formula cell references
Use the INDIRECT function
=INDIRECT("B2") "Superchikn" wrote: Tried that already....Cell reference changes to B$3 "Ardus Petus" wrote: You must reference B$2 HTH -- AP "Superchikn" a écrit dans le message de ... I have a cell that references B2 i need the reference to stay at B2 even if i insert a row at row 2. Currently the reference moves to B3. Is there any way around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use cell contents as references in a formula | Excel Worksheet Functions | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
| Using cell references as text in a formula | Excel Worksheet Functions | |||
| Lock or Unlock cell references in a formula for auto fill purposes | Excel Discussion (Misc queries) | |||
Linear Mode
