Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formulas when inserting rows
Hi,
I have a workbook with 13 sheets which I have to occaisionally add/remove rows. What I need Excel to do is : when I group select all sheets and insert a row, I need all the formulas on each sheet copied to the new row. Is there a way Excel can do this? Thx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formulas when inserting rows
With all sheets selected, after you do the insert, just follow it by the
copy-paste operation that you need to do. Or, if the formulas are in the row above the newly inserted one, do a fill-down after doing the insert. The important thing is that all sheets remain selected while you perform the insert, copy-paste and/or fill-down. Also, if the sheets differ in number of columns, make sure you do all operations to the entire row. "kevhatch" wrote: Hi, I have a workbook with 13 sheets which I have to occaisionally add/remove rows. What I need Excel to do is : when I group select all sheets and insert a row, I need all the formulas on each sheet copied to the new row. Is there a way Excel can do this? Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When Inserting Rows in Excel, not all formulas copy to new row? | Excel Discussion (Misc queries) | |||
Inserting formulas etc after n rows | Excel Discussion (Misc queries) | |||
Inserting Rows w/formulas question | Excel Worksheet Functions | |||
Copy/Insert rows with formulas | Excel Worksheet Functions | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |