Insert multiple rows in Excel?

There used to be an option in the Insert menu of Excel that said "Rows..." which would prompt you for how many rows you wanted to insert.

Now it is just Insert > Rows, which inserts a single row with no prompt.

We are currently on Exel 2k3 with SP 2 installed.

Am I missing something? Did the option move or am I looking in the wrong spot?

Thanks!
LVL 2
OAC TechnologyProfessional NerdsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ducky801Connect With a Mentor Commented:
here is a macro i wrote for you that will accomplish the same task.  highlight any cell in the row at which you want to insert more rows then run this macro.  you can add a button to your toolbar and link it to this macro, use a key combination or run from the macro menu (Alt+F8).  save this code in your personal macro workbook and it will be available to any worksheet you are working with.  if you need help doing any of the aforementioned, let me know..

HTH

AR

_____________________________________________
Sub InsertRows()
Dim RowCount As Integer
Dim count As Integer

On Error GoTo TheEnd

RowCount = InputBox("How many rows shall I insert here?")

count = 0
Do Until count = RowCount
Rows(ActiveCell.Row & ":" & ActiveCell.Row).Select
Selection.Insert Shift:=xlDown
count = count + 1
Loop

TheEnd:
End Sub
________________________________________________________
0
 
FrankcoConnect With a Mentor Commented:
Hi DataDudes,

To insert multiple rows, select the rows above which you want to insert rows. Select the same number of rows as you want to insert. For example, to insert three new rows, you need to select three rows.

cheers,
frankco
0
 
FrankcoCommented:
I know it, would be nice to have an input box or something like before. I guess MS thought this was an improvement.

cheers,
frankco
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
OAC TechnologyProfessional NerdsAuthor Commented:
seriously, that feature is gone now?

i knew it was there at one point :-)
0
 
Anne TroyConnect With a Mentor East Coast ManagerCommented:
Gone. I don't remember when it was there before. :(
I use the F4 key. I'll insert my first row, then hit F4 for each additional row I want.
0
 
FrankcoCommented:
Thank you for the assist DataDudes!

cheers,
frankco
0
All Courses

From novice to tech pro — start learning today.