In Excel for Microsoft 365 on Windows, select a row—or a cell in it—and press Ctrl+Shift+= to insert a row above. To add one below the current row, select the next row first, because Excel inserts new worksheet rows above the selected row.
The fastest keyboard method on Windows
The shortcut is often described as Ctrl+Shift+Plus. On a standard keyboard, that means holding Ctrl and Shift while pressing the key that has the plus sign; on many layouts, this is the equals key. If a whole row is selected, Excel inserts a new worksheet row above it immediately. If only one cell is selected, Excel may show the Insert dialog, where you can choose Entire row.
- Click a cell in the row where the new row should appear, or select the row using its number at the left edge of the sheet.
- Press Ctrl+Shift+=.
- If Excel opens the Insert dialog, choose Entire row and press Enter.
For a simple one-row insertion, selecting the row first makes the result predictable: Excel knows you want a full worksheet row rather than a few cells shifted down. Selecting a row by clicking its numbered heading is especially clear when you are learning the shortcut.
How to insert a row below the current row
Excel’s standard insert-row command places the new row above the selection, not below the active cell. For example, if your data occupies rows 5 through 12 and you want a blank row between rows 8 and 9, select row 9 and use the shortcut. The old row 9 and the rows beneath it move down, leaving the blank row in the intended position.
To insert a row at the bottom of a worksheet list, select the first empty row immediately below the list and insert above it. If the last record is in row 25, select row 26 and insert there. This distinction matters because pressing the shortcut while row 25 is selected creates a blank row before the last record, rather than after it.
When the sheet contains formulas, references, or a formatted range, Excel generally adjusts nearby references as rows are inserted. Still, check formulas and totals after structural changes, especially if the workbook uses manually written ranges that do not include the new row.
Selecting an entire row first
You can select a full row without reaching for the mouse. Click any cell in the target row and press Shift+Space. Then press Ctrl+Shift+= to insert a row above the selected one. This sequence is useful when you are moving through a long sheet with the arrow keys and want to keep your hands on the keyboard.
Be aware that selection behavior can be affected by the active editing state. If the cursor is inside a cell’s text or the formula bar, keyboard commands may edit the cell instead of acting on the worksheet. Press Esc or Enter to leave cell-edit mode, then select the row. If Shift+Space inserts a space while editing, that is a sign the cell is still being edited.
For several blank rows, select the same number of row headings before invoking the shortcut. For example, select rows 10, 11, and 12, then use Ctrl+Shift+= to insert three rows above row 10. The selected rows do not need to be empty; Excel adds the new rows before them and shifts existing content downward.
Ribbon and mouse alternatives
If you cannot remember the key combination, the ribbon offers a direct command. On Windows, select a row or a cell in the target row, then choose Home > Insert > Insert Sheet Rows. The new worksheet row appears above the selection. The command works well when you are already using the ribbon or when a keyboard layout makes the plus shortcut awkward.
You can also right-click a row heading and choose Insert. When you right-click a cell instead, the Insert command may open a dialog so you can specify whether to shift cells, insert an entire row, or insert a column. The row-heading method avoids that ambiguity because the selection is already a complete row.
After inserting, Excel may display an Insert Options button near the new row. Depending on the surrounding formatting, you can use it to keep the format from the row above, match the row below, or clear formatting. This is useful when the blank row inherits a fill color, border, or number format that does not fit the new section.
Inserting multiple rows at once
To add several rows in one action, select that many existing row headings and then use the same shortcut. Selecting four row headings and inserting adds four blank rows above the first selected heading. This is faster and more consistent than repeating the command four times, and it avoids having to reselect the insertion point after each change.
For instance, if a report needs three extra lines before the current row 20, select row headings 20 through 22 and press Ctrl+Shift+=. Three new rows appear above row 20. If you select only row 20 and repeat the shortcut three times, the result is also three rows above the selection, but the selection and active position can change as the sheet updates. A single multirow selection is easier to verify.
When inserting a large block, check that you have selected the intended number of row headings. A quick visual check of the highlighted row numbers can prevent adding too many rows or placing them in the wrong section.
Rows inside an Excel table
Excel tables have their own structure, so a table row is not always the same thing as an ordinary worksheet row. To add a row within a table, right-click a cell in the table near the insertion point and choose Insert > Table Rows Above, if that option appears. This adds a row to the table and typically carries the table’s formatting and calculated-column behavior into the new row.
Another table-specific option is to move to the last cell in the last table row and press Tab. Excel creates a new table row at the bottom when you press Tab from that position. This is convenient for extending a list as you enter records, but it is not the right method for inserting a row in the middle of a table.
If you select a worksheet row heading while working beside a table, you may insert an entire sheet row, affecting cells outside the table as well. Use the table’s row insertion command when you want to change the table alone. After adding a table row, confirm that filters, formulas, and totals still cover the expected range.
Excel for Mac and Excel for the web
In Excel for Mac, the row-insert shortcut is commonly Control+Shift+= after selecting a row; the exact key behavior can depend on the keyboard layout. On some Mac keyboards, entering the plus sign requires Shift, which is why instructions may write the command as Control+Shift+Plus. If the shortcut does not work on your setup, use the ribbon or row-heading context menu instead. Mac menus and keyboard settings can differ from Windows, so do not assume that the Windows Alt-based ribbon sequence will match.
In Excel for the web, keyboard shortcuts can also be affected by the browser and the operating system. Select the row heading and use the available Insert command on the Home ribbon, or right-click the row heading and choose Insert. The web interface may show a slightly different context-menu label, but the key idea remains the same: select the row that should move down, then insert above it.
Some browsers reserve common key combinations for their own commands. If a shortcut changes the browser view or does nothing in Excel for the web, use the ribbon or context menu rather than repeatedly pressing keys. The worksheet command is more reliable than trying to override a browser shortcut.
Common problems and how to fix them
- The shortcut opens a dialog: This is normal when a cell, rather than a complete row, is selected. Choose Entire row, or select the row heading before pressing the shortcut.
- Excel inserts cells instead of a full row: Check whether only a cell or small range is selected. Select the row heading or use Shift+Space first.
- A plus key seems unavailable: On many keyboards, the plus sign shares the equals key, so use Ctrl+Shift+=. A numeric keypad may have a separate plus key, but keyboard layouts vary.
- The shortcut types into a cell: Leave cell-edit mode with Esc or Enter before trying again.
- The new row has unexpected formatting: Use the Insert Options button to choose formatting, or apply the needed number format, borders, and fill manually.
Also check whether the worksheet is protected. A protected sheet may prevent row insertion unless the sheet’s protection settings allow it. If the Insert command is unavailable, ask the workbook owner or review the protection settings rather than assuming the shortcut is incorrect.
Inserting a row is not the same as moving one
The insert shortcut creates a blank row and shifts existing rows down. It does not move the selected row itself. If you meant to move an existing row lower in the sheet, select its row heading, cut it with Ctrl+X, select the destination row heading, and use the context menu’s Insert Cut Cells command where available. Moving rows can change formulas, references, and the order of records, so verify the result afterward.
Likewise, if by “insert row down” you mean filling a selected cell’s value into the cell below, that is a different action: use Ctrl+D to fill down in a selected range. Ctrl+D copies the top cell’s contents or formula downward; it does not add a worksheet row. This is a common source of confusion because both operations involve placing something beneath existing content.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift+=, also written as Ctrl+Shift+Plus. Excel inserts a new worksheet row above the selected row. If only a cell is selected, choose Entire row in the Insert dialog if it appears.
How do I insert a row below in Excel?
Select the row immediately below the location where the blank row should go, then use the insert shortcut. Excel inserts above the selection, so selecting the next row creates the appearance of inserting below the current one.
Can I insert multiple rows with one shortcut?
Yes. Select as many row headings as the number of rows you want to add, then press Ctrl+Shift+=. Excel inserts that number of rows above the first selected row.
What is the Excel shortcut for inserting a row on a Mac?
Excel for Mac commonly uses Control+Shift+= with a row selected, though keyboard layouts can affect how the plus key is entered. If it fails, use the Insert command from the ribbon or the row-heading context menu.
Does Ctrl+D insert a row?
No. Ctrl+D fills the selected cells downward using the top cell’s contents or formula. To add a new worksheet row, select a row and use Ctrl+Shift+= on Windows.
Related
- Unmerge Cells in Excel on iPad: Step-by-Step
- How to Unlock an Excel Sheet or Workbook
- How to Unlock Microsoft Excel: Sheets, Files, and Editing
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Analysis Experience: Skills, Tasks, and ProofExcel data analysis experience means being able to organize data, check its quality, use formulas or tools to…
- How to Add Chicago Footnotes in Word: A Step-by-Step GuideTo add a Chicago-style footnote in Microsoft Word, place the cursor where the citation number should appear, then…
- Make One Page Landscape in Word (Keep Others Portrait)To make just one page landscape in Microsoft Word for Microsoft 365 on Windows, place it in its…
- Count Unique in Google Sheets: Formulas and ExamplesTo count distinct values in Google Sheets, use =COUNTUNIQUE(A2:A100) when the values are in cells A2 through A100.…
- Excel Page Break Keyboard Shortcut and How to Use ItIn Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a manual…
- How to Insert a Checkbox in Word Online for ChecklistsTo add clickable checkboxes in Word Online, open the document, go to Home, and choose Checklist in the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.