Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
parse cell and insert rows? | Excel Worksheet Functions | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions |