How to Insert Row in Excel Shortcut – Add Multiple Rows

You often need to add rows in an Excel spreadsheet for whatever reason. Inserting a new row in a sheet when you are a novice could be sometimes a real headache. You can simply perform this task with a mouse; however, this function would be easier with shortcut commands. Using shortcuts is a real-time saver and here you will find easy ways to how to insert row in Excel shortcuts.

Let’s dive in to see how you can do it:

How to Insert Row in Excel Shortcut?

ALT + I + R Keyboard Shortcut

• Click on a cell in the row given above that you need to insert a new row.

• Once a cell is selected, press ALT + I + R.
• You will see a new row is added above the cell you have selected.

CTRL + SHIFT + Plus Sign (+)

You can use another shortcut command for adding a new row in the sheet. For this:

• Select the row with the help of the keyboard shortcut SHIFT + Spacebar key.

• Now, press CTRL + SHIFT + Plus Sign (+) shortcut command.
• You will see a new blank row is added above the selected row.

More Shortcut Commands to Insert Rows in Excel:

1. You can add a new row above the row in which you currently are. For this, press ALT + I + R.
2. In some cases, you often need to add more than one row above the current row. For this, press ALT + I + R. Once this command is processed, the number of rows you selected above the row in which you have currently selected rows.
3. In case, you need to add a row under the current row, you can use this command.

ALT + I + B

It will simply add a new row under the row you have selected.

4. In case, you need to add more than one row, follow this command:

ALT + I + M + B

5. When you need to add a row at the beginning of the sheet, follow this command:

ALT + I + E

6. When you need to add more than one row at the beginning of the sheet, follow this command:

ALT + I + M + E

It will insert the number of rows you specified at the top of the sheet.

7. When you need to add a row at the end of the sheet, simply follow this command:

ALT + I + N

You will see a new row added at the end of the sheet under the row you have selected.

8. You can add more than one row at the end of the sheet by following this command:

ALT + I + M + N

It will add the number of rows you specified at the end of the sheet.

Things to Remember:

You must know that Excel lets you add rows above the selected row or cell and you cannot change this setting.

Once a row is added, simply press the “Fn + F4” command to add more rows.

When your sheet has more than one dataset, you need to change the data set into a table because Excel adds the row beginning from column A to the end of columns in the sheet.

Summary:

This post has data that explains how to insert row in Excel shortcuts. The above-mentioned shortcut methods simply define how you can add rows in multiple conditions. Try any of the above tricks and you will instantly get what you want.