Same formula in each cell of column; insert rows w/o copying down

[tgdavis]

My spreadsheet has a formula repeated in each cell of a column. Is there
anyway that I can insert rows without having to manually copy down the
formula each time?

 

[Mike]

Just highlight the cell below it and hit ctrl d.

 

[Eric]

Alternatively, you could copy an entire row then insert it where you want the
new row.

Eric

 

[Gord Dibben]

David McRitchie has a macro that may do what you want:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP