| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
stop insert from changing cell reference
I have a cell that references the row above it and three columns to the left.
If I insert a row, the reference changes to two rows above. How can I stop this, and have it stay at one row above? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
stop insert from changing cell reference
Try this example:
D2: =OFFSET(D2,-1,-3) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Peaceful Wisdom" wrote: I have a cell that references the row above it and three columns to the left. If I insert a row, the reference changes to two rows above. How can I stop this, and have it stay at one row above? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
