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? |
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) |