Exceljet

Quick, clean, and to the point

Display Insert Dialog box

Windows shortcut 
CtrlShift+
Mac shortcut 
⌘⇧+

This shortcut will display the Insert dialog box, as long as whole columns or rows are not selected.

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.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
Shortcuts to insert/delete rows and columns
In this lesson, we cover shortcuts you can use to insert or delete cells, rows, and columns.