Windows Mac
CtrlShift+ ⌘⇧+

About This Shortcut 

This shortcut will insert rows as long as at least one row is selected. In a table, this shortcut will insert a row above the active selection when only one cell is selected. If you use the shortcut without a row selected, you'll see the Insert Cells dialog box displayed.

  • 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 italics. 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 How to set up a running total in a table

How to set up a running total in a table

In this video, we'll look at how to set up a running total in an Excel table. Setting up a running total in an Excel table is a little tricky because it's not obvious how to use structured references. This is because structured references provide a notation for current row, but not for first row in …
Excel How to build a pie chart

How to build a pie chart

In this video, we'll look at how to create a pie chart in Excel. Here we have data that shows market share for desktop browsers in 2016. Let's build a pie chart to plot this data. Pie charts show a "part to whole" relationship, and they work best with a limited number of categories. The horizontal …
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.