how to insert more then 1 row at a time..

[RompStar]

so I right click on the row and choose Insert, how can one insert say 10 or 20 rows at the same time... instead of the default 1 ?

thank you.

 

[2rrs]

so I right click on the row and choose Insert, how can one insert say 10 or 20 rows at the same time... instead of the default 1 ?

thank you.

select ten rows; then right click and choose insert

 

[RompStar]

what if there is only one empty row between the data above and below and you want to insert 10 new rows and you can't select 10 blank rows ?

Good idea to maybe put an option like this into Excel for the upcoming upgrades... On the Insert, there should be also an option, Insert (more then one row) and then a window would popup and you would enter the number...

 

[Smitty]

You don't need to have blank rows.

Just select 10 rows beneath the row where you want them inserted and Insert--Rows.

HTH,

Smitty

EDIT:

On the Insert, there should be also an option, Insert (more then one row) and then a window would popup and you would enter the number...

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> InsertRows()
    <SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Integer</SPAN>
        i = Application.InputBox("Enter the number of rows to insert", "Insert Rows", Type:=1)
        
        Range(ActiveCell, ActiveCell.Offset(i - 1)).EntireRow.Insert
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[RompStar]

ahhhh, ok, let me try that .. : -)

that's way cool, I'll make sure to use that script..