Shortcut to Insert Row in Excel: How To Insert A Row Quickly In Excel?

Now quickly add a new Row in Excel with these shortcuts.

  • You need to use the Excel shortcuts to perform any function quickly.
  • There are two shortcuts for adding a Row or Rows in Microsoft Excel.
  • Here’s everything you need to know about it. 

Adding a new Row in your worksheet is an important function in Excel. If you’re a daily Excel user, you know how important it is to insert new Rows quickly and easily. 

That’s why shortcuts exist in Excel, to save you time and hassle going through the right clicks and more on inserting a new Row. 

Sure, adding a new Row doesn’t take all your time, but the time saved is time gained, and if your task of inserting Rows is repetitive, it can add up quickly, and using the shortcut for it could save lots of time and effort. 

In this article, we will discuss how you can insert a new Row or Rows in an Excel worksheet. We will also discuss how to add a Row to the worksheet without shortcuts. Read on. 

Insert Row Shortcuts in Excel

These are shortcuts for inserting rows in Microsoft Excel:

  • Shift + Spacebar – select the row.
  • Alt + I + R – add a new row above this row.

Alternate shortcut for adding a row:

  • Shift + Spacebar – select the row.
  • Ctrl + Shift + + (Plus Sign) – clicking + along with Ctrl and Shift will also give the same result when you select a row.

Here is a step-by-step guide to adding a new Row:

  1. Select a row by clicking Shift + Spacebar shortcut, or select the row above to which you want to add the new row.
  2. Now enter either of the shortcuts – Alt + I + R or Ctrl + Shift + +.
  3. A new row will be added now. 

You can also add multiple Rows similarly. Here’s how to do that:

  1. Select the number of Rows you want.
  2. Now enter either of the shortcuts – Alt + I + R or Ctrl + Shift + +
  3. New Rows will be added in place of the selected Rows, and the existing Rows will be shifted down. 

How To Add Rows In Excel Without Shortcuts? 

Here’s how you add rows in an Excel worksheet without using the shortcuts we discussed above:

  1. Select the row above which you want to add a row. 
  2. Right-click, and from the menu, click Insert. 
  3. A row will be added just before the select row. 

If you want to add multiple Rows, follow this:

  1. Select a number of rows, as many as you want to add. 
  2. Right-click and click Insert. 
  3. A number of rows as much as you selected will be added above your selection. 

Frequently Asked Questions

How do I insert three rows in an Excel cell? 

  1. Select the three cells where you want the new rows to be.
  2. Enter Shift + Spacebar to select the Rows. 
  3. Now enter Alt + I + R to add three new rows to the place. 

Which shortcut to add a Row is better?

Both shortcuts perform the same function and effectively work the same. Which one out of the two is better is a question about preference. I prefer Ctrl + Shift + + shortcut as this combo is easier to type. 

What is the shortcut to insert 10 rows in Excel?

There isn’t a special shortcut for inserting 10 rows in Excel; it is the same shortcut we mentioned earlier for multiple rows.

What is the shortcut to adding columns in Excel?

These are shortcuts for inserting a new column in Microsoft Excel:

  • Ctrl + Spacebar – select the column.
  • Ctrl + Shift + + (Plus sign) – add a new column before this column.

Ctrl + Shift + + shortcut is the same as that of adding row shortcut. The change is that you select a column first instead of selecting a row.