Copy Formulas when inserting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top