| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeat formula with inserted row
Hi, really need some help with the new Excel.
In row 7 I have it setup that K7=(H7-E7) and so row 8 is K8=(H8-E8). Trouble I am having is that when I "insert" row 9 the formula does not repeat and I have to type K9=(H9-E9). What or how do I have to set it up so that any time I "insert" a row that it understands it needs to repeat the formula from the row above it? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fix a formula, so when a row is inserted it doesn't cha | Excel Discussion (Misc queries) | |||
| How to fix a formula, so when a row is inserted it doesn't cha | Excel Discussion (Misc queries) | |||
| Can't get formula to work in inserted column | Excel Discussion (Misc queries) | |||
| formula stays same in cell when new row is inserted | Excel Worksheet Functions | |||
| How do I continue a formula in an inserted row? | Excel Discussion (Misc queries) | |||
Threaded Mode
