Windows Mac
CtrlShift+ ⌘⇧+

About This Shortcut 

This shortcut will insert columns as long as at least one column is selected.

  • With a laptop keyboard, use Control Shift +.
  • With a full keyboard, use Control +

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

Excel Shortcuts to insert/delete rows and columns

Shortcuts to insert/delete rows and columns

In this video, we'll cover shortcuts you can use to insert or delete rows, columns, or cells. To start off, if you first select an entire row or column, you can use a single shortcut to insert new rows or columns. You can select an entire row with shift and the spacebar. Then, to insert a row, use …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.