To insert a row at the end of the sheet and shift the other rows up, press Control + Option + Spacebar.ġ5. To insert a row at the beginning of the sheet and shift the other rows down, press Option + Spacebar.ġ4.

To insert multiple rows below the current row and shift the other rows up, select the number of rows you want to insert, then press Control + Option + Return.ġ3. To insert multiple rows above the current row and shift the other rows down, select the number of rows you want to insert, then press Option + Return.ġ2. To insert a row below the current row and shift the other rows up, press Control + Option + Return.ġ1. To insert a row above the current row and shift the other rows down, press Option + Return.ġ0. To insert multiple rows at the end of the sheet, select the number of rows you want to insert, then press Control + Option + Spacebar.ĩ. To insert multiple rows at the beginning of the sheet, select the number of rows you want to insert, then press Option + Shift + Spacebar.Ĩ. To insert a row at the end of the sheet, press Control + Option + Spacebar.ħ. To insert a row at the beginning of the sheet, press Option + Shift + Spacebar.Ħ. To insert multiple rows below the current row, select the number of rows you want to insert, then press Control + Option + Return.ĥ. To insert multiple rows above the current row, select the number of rows you want to insert, then press Option + Shift + Return.Ĥ. To insert a row below the current row, press Control + Option + Return.ģ.

To insert a row above the current row, press Option + Shift + Return.Ģ. In this article, we'll show you 15 of the best Mac Excel shortcuts to insert a row.ġ. If you're a Mac user, you're in luck, because there are a number of different keyboard shortcuts that you can use to insert rows in Excel on your Mac. If you work with data in Microsoft Excel, you know how important it is to be able to insert rows quickly and efficiently.

Excel shortcut keys insert row