Quick, clean, and to the point

Insert rows

Windows shortcut 
Mac shortcut 

This shortcut will insert rows as long as at least one rows 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 the Insert Cells dialog box displayed.

  • With a laptop keyboard, use Control Shift +.
  • With a full keyboard, use Control +

Note: In Mac 2016, this shortcut was changed to Command Shift +, and now Control + I changes text to italic. In previous Mac Excel versions, Control + I inserts a row (when a row is selected) or brings up the Insert Cells dialog when the selection does not include an entire row.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to insert or delete cells, rows, and columns.
In this video, we'll look at how to create a pie chart in Excel. Pie charts show a "part to whole" relationship, and they work best with a limited number of categories.
Setting up a running total in an Excel table is a bit tricky because it's not obvious how to use structured references. This video explores some options.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.