Solved

Insert multiple rows in Excel?

Posted on 2006-10-31
6
816 Views
Last Modified: 2010-05-18
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!
0
Comment
Question by:OAC Technology
6 Comments
 
LVL 18

Assisted Solution

by:Frankco
Frankco earned 150 total points
ID: 17846761
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
 
LVL 18

Expert Comment

by:Frankco
ID: 17846774
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
 
LVL 2

Author Comment

by:OAC Technology
ID: 17846802
seriously, that feature is gone now?

i knew it was there at one point :-)
0
ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

 
LVL 22

Assisted Solution

by:Dreamboat
Dreamboat earned 150 total points
ID: 17855812
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
 
LVL 5

Accepted Solution

by:
ducky801 earned 200 total points
ID: 17858096
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
 
LVL 18

Expert Comment

by:Frankco
ID: 17971061
Thank you for the assist DataDudes!

cheers,
frankco
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question