Exceljet

Quick, clean, and to the point

Display Insert Dialog box

Windows shortcut 
CtrlShift+
Mac shortcut 
⌘⇧+

This shortcut will display the Insert dialog box. If an entire row or entire column is selected, this shortcut will insert a new row or new column.

Note: In Mac Excel 365, the Control key can be substituted for the Command key. Before Mac Excel 2016, this shortcut was Control + I.

See all shortcuts

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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.