In Excel for Microsoft 365 on Windows, select the row where you want a new row, then press Ctrl+Shift+Plus (+)—usually Ctrl+Shift+= on a standard keyboard. Excel inserts a row above the selected row; if you have selected only a cell, the shortcut opens the Insert dialog so you can choose Entire row.
The Excel shortcut and what it does
The keyboard shortcut for inserting cells, rows, or columns in Excel for Windows is Ctrl+Shift+Plus (+). The exact key you press to produce the plus sign depends on your keyboard. On many US layouts, hold Ctrl and Shift and press the equals key, which is also the plus key. If your keyboard has a separate numeric keypad plus key, Ctrl with that plus key may work as well.
The result depends on what is selected when you use the shortcut. Select a whole worksheet row and Excel inserts a new worksheet row above it. Select a single cell or a group of cells and Excel displays an Insert dialog, because it needs to know whether to shift cells right or down, or insert a full row or column. This distinction explains why the same shortcut can seem to behave differently from one use to another.
For example, if you want a new row between rows 8 and 9, select row 9 and use the shortcut. The new blank row appears above row 9, and the old row 9 and the rows below it move down. Excel does not insert the new row below the selected row.
Insert one row with a quick sequence
When you are working in a worksheet grid, this sequence is usually the quickest:
- Click any cell in the row where the new row should appear.
- Press
Shift+Spaceto select the entire worksheet row. - Press
Ctrl+Shift+Plus (+)to insert a row above it.
You can also click the row number at the left edge of the worksheet to select the whole row, then use the insert shortcut. Selecting the row first is useful because it avoids the Insert dialog and makes the target clear. If you select a cell rather than the whole row, choose Entire row in the dialog and confirm.
Row selection matters when a worksheet contains data in multiple columns. Inserting a full worksheet row makes space across the entire sheet, rather than shifting only a few cells and potentially misaligning neighboring data. If you really do want to shift a local block of cells without affecting the rest of the row, select the cells instead and choose the appropriate option in the Insert dialog.
Insert several rows at once
To insert multiple blank rows in one action, select the same number of existing rows as the number you want to add, then use the shortcut. Excel inserts that many rows above the topmost selected row. For example, selecting rows 12 through 14 and pressing the shortcut adds three rows above row 12.
You can select a range of row numbers by dragging down the row headers, or select a row and extend the selection with Shift+Space followed by the arrow keys while holding Shift. Then use Ctrl+Shift+Plus (+). The key point is the count of selected rows: selecting five rows asks Excel to insert five rows, not one.
This method is often safer and faster than repeating the shortcut several times. Repeated insertions can be less convenient when the same number of rows is needed, and a multirow selection makes the requested count visible before you change the sheet. If you accidentally select too many or too few, cancel the selection and adjust it before inserting.
What happens inside an Excel table
Excel tables have their own structured boundaries and automatic features, such as filter buttons and calculated columns. If you insert a worksheet row within a table, Excel generally expands the table to include that row. The new row can inherit table formatting and may receive formulas from calculated columns. A row inserted immediately below a table may be included in the table when Excel recognizes it as an extension, but do not assume that every blank row near a table is part of it.
To add a row specifically to a table, click a cell in the table row that should move down, select the whole table row if appropriate, and use the insert shortcut. Depending on the selection and location, Excel may show an insertion choice or add a table row. You can also use the table’s context menu or the ribbon’s insert commands. Afterward, check the table boundary and any formulas, especially if the sheet has adjacent data that should remain outside the table.
A useful example is a sales table with columns for date, product, and amount. Adding a row within the table can preserve the table’s formatting and calculated-column formula. Inserting a worksheet row outside the table, by contrast, may create an ordinary blank worksheet row that is not automatically part of the table.
Ribbon and mouse alternatives
If you do not want to use a keyboard shortcut, select a row and choose Home > Insert > Insert Sheet Rows. This command inserts worksheet rows above the selection. You can also right-click a row number and choose Insert. These options are useful when you cannot remember the shortcut or need to confirm that you are inserting full worksheet rows rather than shifting a small selection of cells.
For cells, columns, or less typical selections, the Home tab’s Insert menu offers commands suited to the selection. The right-click menu is context-sensitive, so its choices can differ depending on whether you clicked a cell, a row header, or a table. If the outcome matters, look at the selection outline and the command wording before confirming.
The ribbon provides a discoverable route, but the keyboard method is efficient for repeated editing. A practical workflow is to use the menu once to learn the command, then use the shortcut when inserting rows becomes a regular task. You can still undo a mistaken insertion with Ctrl+Z, provided you have not performed an action that clears or changes Excel’s undo history.
Common shortcut problems and fixes
The most common issue is pressing the wrong plus key combination. On many keyboards, plus is typed with Shift and the equals key, so the shortcut is Ctrl+Shift+=. If you press Ctrl and the equals key without Shift, Excel may run a different command or do nothing. Laptop layouts and non-US keyboard layouts can place the plus sign differently, so use the key that produces plus on your layout.
- An Insert dialog appears: You probably selected a cell or cell range rather than a complete row. Choose Entire row, or select the row first with
Shift+Space. - The row appears in the wrong place: Excel inserts above the selected row. Select the row that currently occupies the position where you want the new row to go.
- Only part of the sheet shifts: You may have selected cells rather than a row. Select the row header or use
Shift+Spacebefore inserting. - The shortcut seems inactive: Check that Excel has focus, that the worksheet is not protected against row insertion, and that the key combination matches your keyboard. If needed, use the ribbon command.
A protected worksheet can restrict structural changes, including inserting rows, depending on the protection settings. In that case, the shortcut is not a workaround: the sheet owner must allow row insertion or remove protection. Also note that a workbook’s filters do not change the basic shortcut, but a filtered or hidden range can make it less obvious which worksheet row is selected. Check the row numbers and visible selection before proceeding.
Windows, Mac, and Excel for the web
This article’s primary shortcut is for Excel for Microsoft 365 on Windows. In Excel for Mac, the row-insertion shortcut is generally Control+Shift+Plus (+); keyboard layouts can affect how you enter the plus sign. On a Mac, Control is not the same key as Command. If the shortcut is inconvenient or does not match your keyboard, select the row and use Home > Insert > Insert Sheet Rows, or use the row header’s context menu.
Excel for the web runs in a browser, where browser or operating-system shortcuts can sometimes interact with Excel’s shortcuts. Select the row and use the ribbon’s Insert command if the keyboard combination is intercepted or behaves differently. The ribbon route also makes the intended action clear when you are unsure whether the selection is a worksheet row, table row, or cell range.
Across these versions, the core idea remains the same: a whole-row selection tells Excel to insert full rows; a cell selection may require an insertion choice. If you work on more than one platform, knowing the ribbon command gives you a dependable alternative even when the keyboard shortcut differs.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
In Excel for Windows, select a row and press Ctrl+Shift+Plus (+), commonly typed as Ctrl+Shift+=. The new row appears above the selected row.
How do I insert a row without selecting the whole row?
Select a cell in the target row and press Ctrl+Shift+Plus (+). In the Insert dialog, choose Entire row. This inserts a full worksheet row rather than shifting only the selected cells.
How do I insert two or more rows in Excel?
Select the same number of existing rows as the number you want to add, then use the insert shortcut. Excel inserts that number of rows above the first selected row.
Does Excel insert a row above or below the selection?
It inserts above. To add a row between rows 20 and 21, select row 21 and insert; the existing row 21 moves down.
What is the Mac shortcut for inserting a row?
In Excel for Mac, use Control+Shift+Plus (+) with the target row selected. The exact key combination for plus can vary by keyboard layout; the ribbon command Home > Insert > Insert Sheet Rows is an alternative.
Why does Excel show an Insert dialog instead of adding a row?
The selection is probably a cell or group of cells, not a complete worksheet row. Choose Entire row in the dialog, or select the row first with Shift+Space and repeat the shortcut.
Related
- Excel Split Cell Into Multiple Cells: Methods That Work
- Excel Split Names in One Cell Into Two Cells
- Excel Split One Cell Into Multiple Rows: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Hanging Indent in Word: A Simple Step-by-Step GuideTo add a hanging indent in Word, select the paragraph or paragraphs, open the Paragraph settings, and choose…
- How to Clear Cache in New Microsoft Outlook on WindowsTo clear cached app data in New Outlook for Windows, close Outlook, then open Windows Settings and choose…
- Excel Power Query: Merge All Files in a FolderTo merge files from a folder in Excel for Microsoft 365 on Windows, select Data > Get Data…
- How to Split an Excel Cell Into Two (and What Works)Excel cannot split one worksheet cell into two independent cells the way you can split a cell in…
- Excel Consolidate Multiple Columns Into OneYes. To combine values across columns on the same row, enter a formula such as =TEXTJOIN(" ",TRUE,A2:C2) in…
- Microsoft Excel Contact List Template: Setup and TipsYes—Microsoft Excel can provide a contact list template: in Excel for Microsoft 365 on Windows, select File >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.