| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding new rows and keeping the same formulas
Hi,
I'm wondering if there is a way I can add new rows and keep the same formulas in the newly added rows, instead of having to write the formulas back into the cells one by one. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding new rows and keeping the same formulas
I think this is what you meant:
Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm I would be a lot nicer to answer questions for people who use their name (first and last) in the newsgroups. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm wrote I'm wondering if there is a way I can add new rows and keep the same formulas in the newly added rows, instead of having to write the formulas back into the cells one by one. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding new rows and keeping same formulas | Excel Discussion (Misc queries) | |||
| 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 | |||
Hybrid Mode
