In Excel for Microsoft 365 on Windows, select the row where you want a new one, then press Ctrl+Shift+= (the plus-sign shortcut). Excel inserts a row above the selected row; if you have selected only a cell, the Insert dialog lets you choose to insert an entire row.
The Windows shortcut and what it does
The shortcut people usually mean by “insert row” is Ctrl+Shift++, often written as Ctrl+Shift+Plus. On most keyboards, the plus sign shares the equals key, so hold Ctrl and Shift and press the = key. This produces the plus-sign command without requiring a separate key labelled +. If your keyboard has a numeric keypad with a dedicated plus key, Ctrl with that key may also work.
Excel inserts the row above the selection, not below it. For example, if row 8 is selected, the new blank row becomes row 8 and the former row 8 moves down to row 9. This distinction matters when you are adding a line beneath a heading or keeping data in a particular order: select the row that should move down.
The command can also insert cells, depending on what is selected. If you select a single cell or a rectangular range of cells, Excel opens the Insert dialog so you can choose whether to shift cells down, shift cells right, insert an entire row, or insert an entire column. Selecting a full worksheet row before using the shortcut makes your intention clear and inserts a whole row directly.
Insert a row in three steps
For a predictable result, use the row header at the left edge of the worksheet to select the row. Then invoke the shortcut. These steps work in desktop Excel for Microsoft 365 on Windows:
- Click the numbered row header for the row that should move down. To insert above row 12, select row 12.
- Press
Ctrl+Shift+=to send the insert command. - Check the result: a blank worksheet row should appear above the selected row.
You can select a row without using the mouse: click a cell in it and press Shift+Space. Then press the insert shortcut. Depending on your keyboard layout, selecting the row this way may be more convenient than reaching for the row header. If the shortcut opens an Insert dialog instead of immediately adding a row, check that the entire row—not just one cell—is selected. In the dialog, choose Entire row and confirm.
To insert at the top of a sheet, select row 1 first. Excel adds a new row above it, so the existing first row shifts to row 2. The same rule applies anywhere in the worksheet: the selected row is the position where Excel makes room.
Insert multiple rows at once
To add several adjacent blank rows in one operation, select the same number of existing rows as the number you want to insert, then use the shortcut. For example, selecting rows 5 through 7 and pressing Ctrl+Shift+= inserts three blank rows above row 5. The original rows 5 through 7 move down together. This is often faster and more consistent than repeating the command one row at a time.
Use consecutive row headers for this method. If you need four new rows between two sections, select four row headers at the boundary, then insert. Be careful to select the correct count: selecting one row inserts one, even if the worksheet contains a large block of data around it. Before inserting many rows into a shared or heavily formatted workbook, confirm that formulas, totals, and references still point to the intended data afterward.
Excel worksheets have a fixed maximum of 1,048,576 rows. If a sheet is already at that limit and contains data at the bottom, Excel may not be able to add another row because there is no space to shift the existing content down. In ordinary worksheets this is uncommon, but it can matter when importing very large datasets.
Rows in an Excel Table
An Excel Table is a formatted data range with features such as filter buttons and automatic expansion. Inserting a worksheet row and adding a table row are related but not always identical tasks. If you want a new record to belong to the table, make sure the inserted row is within the table or use a table-specific command.
One direct method is to right-click a table row and choose Insert, then select a table-row option such as Table Rows Above when it is available. The exact menu choices depend on where you right-click. You can also place the cursor in the table’s last cell and press Tab to create a new table row at the bottom. That is useful when entering records in sequence, but it does not add a row at an arbitrary position in the middle.
When inserting above a table row, Excel generally expands or adjusts the table so the new row participates in the table’s structure. Still, check the table boundary after the operation. If the new blank row ends up outside the table, its filter, structured references, and table formatting may not behave like those of the other records. A worksheet row added immediately above a table may also affect nearby content outside the table, so use the table’s own insert option when the intent is specifically to add a record.
Ribbon and right-click alternatives
If you cannot remember the keyboard combination, Excel provides commands on the ribbon. Select the row, then choose Home > Insert > Insert Sheet Rows. The wording distinguishes inserting worksheet rows from inserting cells or columns. You can also right-click the selected row header and choose Insert. Both approaches are useful when working on a keyboard layout where the plus shortcut is awkward or when you want to confirm the command visually.
For a single cell selection, use Home > Insert > Insert Sheet Rows to make the whole-row intention explicit. By contrast, the Insert command in a cell’s context menu may open a dialog with choices about shifting cells. Read the options before confirming: choosing Shift cells down is not the same as inserting an entire worksheet row, and can leave adjacent columns misaligned.
These alternatives are particularly handy when teaching someone the operation or when a shortcut is intercepted by another application or a remote desktop. The ribbon command is also a useful fallback for accessibility setups that remap keys. The underlying result is the same when the entire row is selected: Excel makes space above that row and shifts existing worksheet content down.
Windows, Mac, and Excel for the web
This page focuses on Microsoft 365 Excel for Windows. On a Mac, the insert-cells command is generally Control+Shift++ (often entered with Control, Shift, and the = key on keyboards where + shares that key). Select the whole row first if you want to avoid the Insert dialog and insert a complete row. Mac keyboard layouts and Excel settings can affect how the plus key is entered, so the reliable fallback is to use the ribbon’s Insert command or the row-header context menu.
Excel for the web runs in a browser, where some keyboard combinations may be handled differently by the browser or operating system. If the desktop shortcut does not work in the browser, select the row and use the ribbon’s Home > Insert command, or open the row-header context menu and choose Insert. Check the visible menu wording in your version, since web and desktop interfaces can differ.
On Windows laptops, there may not be a dedicated plus key. The plus sign is commonly entered with Shift and the equals key, which is why the shortcut is often written as Ctrl+Shift+=. If your keyboard layout uses a different key for +, follow the layout’s plus-key combination while holding Ctrl, or use the ribbon method rather than guessing.
Common problems and quick fixes
- The Insert dialog appears. You probably selected a cell rather than a full row. Choose Entire row in the dialog, or select the row header first and repeat the shortcut.
- The row appears in the wrong place. Excel inserts above the selection. Select the row that currently occupies the position where the new row should go.
- Only cells shift and the columns no longer line up. You inserted cells rather than an entire worksheet row. Undo immediately with
Ctrl+Zif appropriate, then select the row header and insert the row. - The shortcut does nothing. Confirm that Excel has focus, that the worksheet is not protected against inserting rows, and that you are pressing the plus sign rather than Ctrl and Shift with no key. Try the ribbon command to identify whether the issue is the shortcut or a worksheet restriction.
- Excel will not insert rows. A protected sheet may restrict row insertion, and a sheet at its row limit may have no room to shift existing data. Check the protection settings or whether data occupies the bottom of the worksheet.
Undo is useful if you insert in the wrong place, but it is best to verify the selection first in a workbook with dependent formulas or carefully arranged formatting. Inserting a row usually adjusts many formulas and references automatically, but formulas that rely on fixed ranges, external data, or particular row positions deserve a quick check.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
In Excel for Microsoft 365 on Windows, select a row and press Ctrl+Shift+=, the plus-sign shortcut. Excel inserts a new row above the selected row.
How do I insert a row above the current row?
Select the row by clicking its number at the left, then use the insert shortcut or choose Home > Insert > Insert Sheet Rows. The selected row moves down to make room.
How can I insert several rows at once?
Select as many adjacent row headers as the number of rows you want to add, then use the insert shortcut. Selecting three rows inserts three blank rows above the first selected row.
Why does Excel show an Insert dialog instead of adding a row?
The selection is probably a cell or cell range rather than a full worksheet row. Choose Entire row in the dialog, or select the row header before pressing the shortcut.
What is the row-insert shortcut on a Mac?
Excel for Mac generally uses Control+Shift+Plus for the insert command. Select the row first; if your keyboard layout makes the plus key difficult to enter, use the Insert command on the ribbon or the row-header context menu.
Does inserting a row add a new row to an Excel Table?
It can if the insertion is made within the table, but a worksheet row outside the table is not automatically the same as a table record. For a table, use its Insert option or press Tab from the final table cell to add a row at the bottom.
Related
- Power Query Background Refresh in Excel: How to Disable It
- Excel Cleanup Taking Too Long? Make Cleanup Faster
- Excel Percentage Number Format: 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
- How to Remove Split Screen in Excel: Steps and FixesTo get rid of split screen in Excel for Microsoft 365 on Windows, select View > Split once…
- How to Schedule an Email in Outlook for a Later TimeTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- Markdown Merge Cells: What Works and What Does NotNo: standard Markdown tables do not support merged cells. If your Markdown renderer allows HTML, you may be…
- Excel Freeze Panes in Two Directions: Rows and ColumnsYes. In Excel for Microsoft 365 on Windows, you can freeze rows and columns at the same time:…
- How to Work Out Percentages in Google Sheets EasilyTo work out a percentage in Google Sheets, divide the part by the total, then format the result…
- Google Sheets Duplicate File: How to Make a CopyTo duplicate a Google Sheets file in a web browser, open the spreadsheet and choose File > Make…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.