EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Insert Multiple Rows in Excel
 

Insert Multiple Rows in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

How to Insert Multiple Rows in Excel (Examples)

Insert Multiple Rows in Excel is used when we insert multiple rows at a time. For this, please choose the number of rows we want to insert. Suppose we want to insert 4 rows at a time; then select 4 rows in sequence and click on the right to choose Insert. There is another way to determine the number of rows we want to insert, then press Ctrl + Shift + “+” (Plus) together.

 

 

Insert multiple rows

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Insert Multiple Rows in Excel (Table of Contents)
  • Example #1 – Insert a Single row using a mouse
  • Example #2 – Insert Multiple rows using the Mouse shortcut

Top 2 Insert Multiple Rows in Excel (Examples and Shortcut)

There are multiple ways of inserting multiple rows in Excel. How to do this, we will learn step by step with examples.

You can download this Insert Multiple Rows Excel Template here – Insert Multiple Rows Excel Template

Example #1 – Insert a Single row using a mouse

Let’s consider some stationary data:

Insert multiple rows example 1

For inserting a single row using a mouse shortcut, follow the below steps:

  • Select the whole row below where you want to insert a new row. For Example, if you insert a row between the 7th & 8th row, select the 8th row, and do right-click, and a drop-down list will open. Click on the insert option below the screenshot:

Insert multiple rows example 1 - 2

  • It will insert a blank row below the 7th

Insert multiple rows example 1 - 3

Example #2 – Insert Multiple Rows using the Mouse Shortcut

Let’s take the same stationary data:

Insert multiple rows example 2

Using the mouse, we can insert multiple rows at a time. Follow the below steps:

  • Select the number of rows below the row where you want to insert the rows. For Example, if you’re going to insert the 4 rows below row no. 3, then select the rows from row no. 4 to row no. 7. Refer to the below screenshot:

Insert multiple rows example 2.- 2

  • Do right-click. Drop down list will open. Click on the insert option.

Insert multiple rows example 2.- 3

  • It will insert the 4 rows below row no. 3, as in the below screenshot.

Insert multiple rows example 2 - 4

Insert rows by using Excel Ribbon:

  • Select the row and go to the HOME tab. Click on the INSERT option under the Cells section. Refer to the below screenshot:

Insert multiple rows example 2 - 5

  • It will open a drop-down list. By clicking on Insert Sheet Rows

Insert multiple rows example 2 - 6

  •  It will insert a row above the selected row.

Insert multiple rows example 2 - 7

Insert rows by using the Keyboard shortcut:

  • Select the row below (where you want to insert the row) using the keyboard shortcut SHIFT-SPACEBAR of the keyboard.
  • The whole row will be selected.
  • Press the SHIFT-CTRL-+ sign to insert a row.

Using the Insert copied cells option:

  • It’s a quick way to insert multiple rows in Excel. Select the blank row.

example 2 - 8

  • Copy it & Select the above rows where you want to insert the new row. If you want to insert multiple rows, select the number of rows. We want to insert 3 rows, so we selected the 3 rows. Refer to the below screenshot:

example 2 - 9

  • Do right-click. Drop down list will open. Click on the Insert Copied Cells option.

example 2 - 10

  • Per the screenshot below, it will insert the multiple rows as we want.

example 2 - 11

Things to Remember

  • The keyboard shortcut is the easiest way to insert the rows in a worksheet.
  • It saves a lot of time in Excel while creating reports or working with vast amounts of data.

Recommended Articles

This has been a guide to the Insert Multiple Rows in Excel. Here we discuss the Insert Multiple Rows in Excel and how to create the Insert Multiple Rows in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. VBA Insert Row
  2. Add Rows in Excel Shortcut
  3. ROWS Function in Excel
  4. How to Sum Multiple Rows in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Insert Multiple Rows Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Insert Multiple Rows Excel Template

EDUCBA

डाउनलोड Insert Multiple Rows Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW