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.
In this lesson, we cover shortcuts you can use to insert or delete cells, rows, and columns.
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.