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

Tip:  Shortcuts for Excel Tables
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Tip: How to create a running total in a Table
Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with the @ notation, but what about the first row in a column? You might be surprised that you can use INDEX for this.