| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows while keeping cell contents the same
When I insert a row, it will give me a blank row. I am trying to insert a
row in the middle of many rows of formulas, and I want the row to be auto-populated with the correct formula. Instead of: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted and blank) Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk I want: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk My actual spreadsheet is more complicated, but the principle is what I need to get working. JD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting rows keeping the merged cells | Excel Discussion (Misc queries) | |||
| Keeping Formulas the same when inserting columns | Excel Discussion (Misc queries) | |||
| Keeping contents of cell A1 showing when scrolling. | Excel Worksheet Functions | |||
| Taking contents of a cell an inserting them into a phrase. | Excel Discussion (Misc queries) | |||
| Inserting new row but keeping formulae | Excel Worksheet Functions | |||
Threaded Mode
