Quick, clean, and to the point

Display Insert Dialog box

Windows shortcut 
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.

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.