Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

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!
0
OAC Technology
Asked:
OAC Technology
3 Solutions
 
FrankcoCommented:
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
 
OAC TechnologyProfessional NerdsAuthor Commented:
seriously, that feature is gone now?

i knew it was there at one point :-)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DreamboatCommented:
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
 
ducky801Commented:
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
 
FrankcoCommented:
Thank you for the assist DataDudes!

cheers,
frankco
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now