Inserting rows

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

Is there a another way, other than to select the number of
rows that you want, to insert multiple rows? I have
existing spreadsheets that I have to modify, where I have
to insert hundreds of rows. It is tedious to have to
continually select 800-900 rows so that I can insert them.
If anyone can help, thanks!

Dino
 
Dino

What would be the criteria upon which you decide where to insert the rows?

Perhaps someone can come up with a solution.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Thanks for the reply Gord,
It really doesn't matter WHERE the inserted rows are. We
have a blank template (with calculations at the bottom)
that has only two hundred rows, but if I need 800 rows for
example, then I have to insert them somewhere above the
calculated cells, and below the column headings before I
copy and paste the data into the template. It just gets
tedious having to select 600 rows so that I can insert
them. Help!
-----Original Message-----
Dino

What would be the criteria upon which you decide where to insert the rows?

Perhaps someone can come up with a solution.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
Click to expand...
 
Dino

Macro solution.......

Public Sub insertrows()
rowstoinsert = InputBox("How many Rows")
With ActiveCell
.Resize(rowstoinsert, 1).EntireRow.insert
End With
End Sub

Copy/paste to a general module in your workbook.

If not sure how to do this.........

With your workbook open, hit ALT + F11 to open the Visual Basic Editor.
View>Project Explorer.

Select your workbook project and Insert>Module. Copy/paste the code into
here.

ALT + Q to go back to Excel. Select a cell where you want to insert rows
below and ALT + F8 to open Macros dialog box. You will see the "InsertRows"
macro. Click "Run".

You can assign this macro to a button or a shortcut-key combo.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

Thanks for the reply Gord,
It really doesn't matter WHERE the inserted rows are. We
have a blank template (with calculations at the bottom)
that has only two hundred rows, but if I need 800 rows for
example, then I have to insert them somewhere above the
calculated cells, and below the column headings before I
copy and paste the data into the template. It just gets
tedious having to select 600 rows so that I can insert
them. Help!
Click to expand...
 
Back
Top