| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding new rows and keeping same formulas
Formulas can typically be copied down. For example, if you have in C1
the following formula: =A1*B1 then you can copy it down and the cell references will change. For example, in C5, it will automatically become =A5*B5 If such is the nature of your formula, then you can fearlessly insert rows and then simply copy the existing formulas along the entire column. HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping rows intact during sort | Excel Discussion (Misc queries) | |||
| keeping formulas static when cutitng and pasting associated celldata | New Users to Excel | |||
| Keeping a series table from updating when adding new rows. | Charts and Charting in Excel | |||
| Keeping duplicate rows | Excel Worksheet Functions | |||
| copy / paste selective rows | Excel Discussion (Misc queries) | |||
Threaded Mode
