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"
<[email protected]> 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?
>