How to Insert Multiple Rows in Excel

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Inserting rows in Excel is one of the most basic, repetitive tasks you’ll come across.

Adding one is quick and easy. But how do you manage if you need to add multiple rows?

Sure, you can add one row at a time. But if what if you need to add a hundred rows?

In this article, we’ll show you how to insert multiple rows in Excel. There are different ways you can do it and all of them are super easy.

Kasper Langmann, Co-founder of Spreadsheeto

Let’s get into it! 😊

Get your FREE exercise file

Before you start:

Throughout this guide, you need a data set to practice.

I’ve included one for you (for free).

Download it right below!

Download the FREE Exercise File

Download exercise file

Insert Feature

Using the tools and features in the Ribbon is probably how you’ll first learn to do things in Excel.

Similarly, there is an ‘Insert’ tool right in the Ribbon under the ‘Cells’ group of the ‘Home’ tab.

To insert multiple rows using this tool, select first where you would like to insert the rows.

The number of rows selected will determine how many rows will be inserted. So selecting 3 rows will yield 3 new rows.

Kasper Langmann, Co-founder of Spreadsheeto

You can do this in two ways:

  • Select the cells in which rows you would like to insert the rows and press ‘Shift’ + ‘Space’ to select the rows where the cells are located
  • Directly select the rows by clicking their respective column numbers
select the whole row by pressing shift plus space
select rows through highlighting row numbers

Then, make sure you’re on the ‘Home’ tab.

home tab on tab list

Click the ‘Insert’ icon found on the ‘Cells’ group.

After clicking the icon, you’ll immediately see the inserted rows on the worksheet.

Access Key Combination

One of the beauties in Excel is that you’re able to perform functions using key combinations.

For example, the steps defined in the second chapter of this tutorial includes pressing the ‘Insert’ icon.

There’s a way to do that without the mouse.

  • Insert: ‘Alt’ + ‘i’
  • Row: ‘Alt’ + ‘r’

In short, you can insert rows by holding down ‘Alt’ + ‘i’ + ‘r’ assuming you already have selected the destination for the rows.

Kasper Langmann, Co-founder of Spreadsheeto

Insert Row Keyboard Shortcut

Inserting or deleting a row or column is one of the little-known but super useful Excel shortcuts.

You can insert multiple rows by pressing ‘Ctrl’ + ‘Shift’ + ‘+’ (‘^’ + ‘I’ for Mac).

Easy, right? 😊

Wrapping things up…

Knowing how to quickly insert multiple rows in Excel will save you lots of time. Out of the 4 methods we showed you, what we like best is the shortcut. 😊

When you need to insert multiple rows, remember that the number of rows selected will also determine how many rows will be inserted.

Kasper Langmann, Co-founder of Spreadsheeto