Learn How to Insert Rows With Shortcut in Microsoft Excel

Insert Rows With Shortcut in Microsoft Excel

Here we will show you how to insert rows in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts.

You can use the key combinations given below to insert rows using the shortcut. Using this shortcut you can able to insert rows as long as at least one row is selected. In a table, this shortcut will insert a row above the active selection when only one cell is selected. If you use the shortcut without a row selected, you'll see the Insert Cells dialog box displayed.

Use "Control Shift +" when using the laptop keyboard.

Use "Control +" while using a regular keyboard.

While the Mac users,  this shortcut was changed to Command Shift +, and now Control + I change the text to italic. So, here we go:

How to Insert Rows With Shortcut in Microsoft Excel?

It is used to insert rows in Microsoft Excel. Using this shortcut you can able to insert rows as long as at least one row is selected. In a table, this shortcut will insert a row above the active selection when only one cell is selected. If you use the shortcut without a row selected, you'll see the Insert Cells dialog box displayed.

While the Mac users,  this shortcut was changed to Command Shift +, and now Control + I change text to italic. This way you can easily insert rows using this shortcut.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel