Insert a row
 

I have a worksheet which is 25 columns wide and I need the abilitiy to
occasionally insert a row.

When I insert the row I need all formatting brought down and the formulas in
column A, Y and Z copied down.

Insert a row
 

copy the last working row Cols A-AZ in one swoop and paste this in your new
row.
Formulae/formatting will go with the paste.

"ordnance1" wrote:

I have a worksheet which is 25 columns wide and I need the abilitiy to
occasionally insert a row.

When I insert the row I need all formatting brought down and the formulas in
column A, Y and Z copied down.