| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jumping reference cell in dependent cell formula
Let's say I want cells E1:E10 to be the same as A1:E10. I insert formulas by
putting =A1 in cell E1, =A2 in cell E2, and so on and it works nicely until I shift data down one cell using copy and paste in column A to add in a new piece of data. Upon doing this now cell E1=A2 and so on. How can I keep the formulas from changing? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Jumping reference cell in dependent cell formula
"jpeterspro" wrote in message
... Let's say I want cells E1:E10 to be the same as A1:E10. I insert formulas by putting =A1 in cell E1, =A2 in cell E2, and so on and it works nicely until I shift data down one cell using copy and paste in column A to add in a new piece of data. Upon doing this now cell E1=A2 and so on. How can I keep the formulas from changing? Why not insert a new row for your new piece of data, rather than moving the old data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula trouble, dependent cell | Excel Discussion (Misc queries) | |||
| Formula dependent on a cell entry | Excel Discussion (Misc queries) | |||
| Need help with a Multiply Dependent One Cell Formula | Excel Worksheet Functions | |||
| Can I create a formula dependent on if a cell is highlighted or no | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
