Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Insert multiple rows in Excel?

Posted on 2006-10-31
6
Medium Priority
?
822 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 18

Assisted Solution

by:Frankco
Frankco earned 600 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 22

Assisted Solution

by:Dreamboat
Dreamboat earned 600 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 800 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

730 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