Exceljet

Quick, clean, and to the point

Insert rows

Windows shortcut 
CtrlShift+
Mac shortcut 
I

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.

Note: In Mac 2016, this shortcut was changed to Control Shift + (same as Windows), 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.
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.
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.
In this lesson, we cover shortcuts you can use to insert or delete cells, rows, and columns.