This shortcut allows you to delete a row. The new row will be inserted above the selected cell, and the existing rows will be shifted down. Simply select the cell where you want to insert the new row and press Ctrl + Shift + + (plus sign) on your keyboard. This shortcut allows you to insert a new row above the selected cell. Shortcut #1: Ctrl + Shift + + (Plus Sign) In this article, we will explore seven amazing keyboard shortcuts for inserting rows in Excel. Fortunately, there are several keyboard shortcuts that can help you save time and increase your productivity. However, it can be time-consuming to perform certain tasks, such as inserting rows. So get out there and start using them!Įxcel is a powerful tool that can help you organize and analyze data with ease. That's it! These seven keyboard shortcuts for inserting rows in Excel will have you zipping through your work in no time. These shortcuts will insert a new row at the very top or bottom of your sheet, respectively. You can also use the Ctrl+Alt+ shortcuts to insert rows above or below the row you have currently selected, respectively.įinally, if you want to insert a row at the very top or bottom of your sheet, you can use the Ctrl+Shift+Home or Ctrl+Shift+End shortcuts, respectively. These shortcuts will insert a new row above or below the row you have currently selected, respectively. If you want even more control over where your rows are inserted, you can use the Ctrl+Shift+ shortcuts. To insert rows below the selected row, use the Ctrl+Alt+O shortcut. If you want to insert multiple rows, just keep pressing the I key.

This shortcut will insert a new row above the row you have currently selected. To insert rows below the selected row, use the Ctrl+Shift+- shortcut.Īnother great keyboard shortcut for inserting rows is Ctrl+Alt+I. If you want to insert multiple rows, just keep pressing the + key.

The first keyboard shortcut for inserting rows in Excel is Ctrl+Shift++. And if you're not a power user, you're about to become one! These seven keyboard shortcuts for inserting rows in Excel will have you zipping through your work in no time. If you're an Excel power user, you know that keyboard shortcuts can save you a ton of time.

Insert row shortcut excel