Inserting Rows to Include Column Formula

[Dean]

Hi Group,

When I insert new rows into a spreadsheet who's columns
contain formulas, is there a way to have the formulas of
that specific column automatically apply to in the
appropriate newly inserted cells ? Right now I am
manually copying and pasting the column formula from the
individual cells above the newly inserted row which is
quite tedious.

Thanks

 

[Frank Kabel]

Hi
see:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

 

[Chris Mitchell]

Would Copy, Paste Copied Cells do it if you used Paste Special and selected
All?