EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Formula and Functions Insert Rows in Excel
Secondary Sidebar
Insert Rows in Excel

Advanced Excel Formulas and Functions

Compatibility Mode in Excel

Excel Template for Payroll

VLOOKUP Names

Advanced Formulas in Excel

Insert Rows in Excel

What is Insert Rows in Excel?

To Insert rows in Excel means adding new empty rows in between the existing rows so that you can add new information or data to your table. It’s like adding a new line between two sentences, but in Excel, you add a new row between two existing rows.

For example, a teacher wants to add the data of two more students to an existing dataset and, therefore, can insert two blank rows above the desired row as seen in the image.

Insert Rows in Excel

Start Your Free Excel Course

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

Insert Rows

Key Highlights

  • You can insert a maximum of 1000 rows into a table.
  • You can insert multiple rows at once by selecting the same number of rows, right-clicking the selection, and then choosing Insert.
  • The shortcut to insert rows in Excel is pressing the keys CTRL + Plus sign (+) However, it works only for devices with a numeric keypad to the right of a regular keyboard.
  • For those devices that do not have the numeric keypad to the right, the shortcut is pressing the keys CTRL + SHIFT + Plus sign (+).
  • You can repeat to insert in Excel rows by pressing Fn + F4

How to Insert Rows in Excel?

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

Example #1: The table below shows a list of students with their roll numbers. We want to insert a row and add the data of one more student above the details of Emma. Let’s see how we can do this-

Insert Rows in Excel example 1

Step 1– Open the Excel worksheet consisting of the data in which you want to insert a row.

Step 2– Select the row above which you want to insert a new blank row; in this case, row no. 11.

Insert Rows in Excel step

Note: To select an entire row, click on the row header on the left-hand side of the worksheet. To select multiple rows, click and drag your mouse over the row headers [see the below image]

Note

Step 3– Right-click on the selected row.
It will open a context menu with a list of options.
Step 4- Click on Insert in the context menu.

Insert in the context menu

Step 5– Excel inserts a new blank row above the selected row.

inserts a new blank row

Shortcut to Insert Rows in Excel

Consider the example above to understand using shortcuts for inserting rows in a data set.

#1: CTRL + (+)

Step 1– Select the row above which you want to insert a new blank row.

Step 2– Press CTRL & plus sign (+) together

CTRL + +

Next Step – Excel will insert a new row above the selected row.

CTRL + + Insert row

#2: ALT + I +  R

Step 1- Select the row above which you want to insert a new blank row.

Next Step – Press the keys ALT, and I, followed by the letter R on the keyboard.

ALT + I + R

Step 5– It will insert a new row above the selected row.

CTRL + + Insert row

#3 How to Insert Multiple Rows Using a Shortcut Key?

The following table has a list of fruits being sold five days a week. We want to add the data for three more fruits to the list. Let us insert three blank rows below Banana using the shortcut keys.

Insert Multiple Rows Using a Shortcut Key

Step 1- Select the same number of rows as the new rows you want to insert. You want to insert three new rows here, so select three existing ones.

Insert Multiple Rows Using a Shortcut Key step 1

Step 2- Press CTRL + (+)

Insert Multiple Rows Using a Shortcut Key step 2

It will insert three new blank rows above the selected rows.

Insert Multiple Rows step 2

#4 Insert a Row or Column Adjacent to the Table

Consider a table consisting of the names of five salesmen with the sales they achieved in January, February, March, April, and May. We want to add the sales data for June too. 

Insert a Row or Column Adjacent to the Table

Let us see how we can add a row/column adjacent to a table-

Step 1: Place your cursor in an adjoining cell and type the desired value (here, it is the month of June)

Step 2: Press Enter key

Insert a Row or Column Adjacent to the Table step 2

A new column will be inserted adjacent to the table with the same formatting as the table.

Insert a Row or Column Adjacent to the Table step 2.1

#5 Insert a Row within a Table

Using the same example, we will add a new row within the table.

Insert a Row or Column Adjacent to the Table

Step 1: Select the cell above which you want to insert a new row. Here, it is cell A8 (James)

Insert a Row within a Table step 1

Step 2: Go to the Home tab > Insert under the Cells group > Insert Table Rows Above

Insert a Row within a Table step 2

It will insert a blank row above the row containing cell A8.

Insert a Row within a Table blank row added

Frequently Asked Questions (FAQs)

Q.1 How do I insert multiple rows in Excel?
Answer: To insert multiple rows in Excel quickly, follow these steps:

  1. Select the same number of rows as the new rows you want to insert.
  2. Press ALT + H + I + R
  3. Excel will insert the same number of new blank rows above the selected rows, and you can begin entering data in the new cells.

insert multiple rows in Excel

insert multiple rows in Excel 1

Q2. How to insert multiple rows in Google sheets?
Answer: To insert multiple rows in Google sheets, follow these steps:

Step 1: Select the same number of rows (here 4) that you want to insert.

Step 2: Go to Insert > Rows > Choose Insert 4 rows above/ Insert 4 rows below

insert multiple rows in Google sheets

Q3. How do I insert rows into an Excel table?
Answer: To insert rows in Excel table, follow these steps,

Step 1: Select the table row above which you want to insert a new row

Step 2: Go to Home > Insert > Insert Sheet Rows

insert rows into an Excel table

insert rows into an Excel table

Recommended Articles

This is EDUCBA’s guide on Insert Rows in Excel. For more comprehensive articles, we recommend referring to EDUCBA’s following articles.

  1. Advanced Excel Formulas and Functions
  2. OR in Excel
  3. Excel IF Function
  4. Excel Keyboard Shortcuts
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Data Analysis Training (17 Courses, 8+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - 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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*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 Rows in Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Insert Rows in Excel Template

EDUCBA

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

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more