Inserting Rows to Include Column Formula

D

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
 
C

Chris Mitchell

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