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

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?

Just highlight the cell below it and hit ctrl d.

"tgdavis" wrote:

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?

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

Eric


"Mike" wrote:

Just highlight the cell below it and hit ctrl d.

"tgdavis" wrote:

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?

From a Dave Peterson post to the wrong posting<g

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

On Wed, 14 Sep 2005 11:06:45 -0700, "tgdavis"
wrote:

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?