| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Insert New Row without shifting formula
e.g. I have a formula in cell B4 that calculates data in column cells
C4 to, say, M4. (e.g. "=Sum($C4.$M4)") I then wish to insert a new C4 row, copy a new set of data into the new C4, but use the same formula in B4 to calculate the new totals ("=Sum($C4.$M4)"). However, when I insert the new row for C4, the formula in B4 shifts to now say "=Sum($D4.$N4)". Is there an easy way to make this work ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| insert a new cell into an existing formula | Excel Discussion (Misc queries) | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| How to insert easily the text of a scientific formula | Excel Discussion (Misc queries) | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Threaded Mode
