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.
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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.