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

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