In Excel for Microsoft 365 on Windows, select the row where you want the new one, then press Ctrl+Shift+= (the plus shortcut). Excel inserts a blank row above the selected row. If you have selected a cell rather than a whole row, the shortcut opens the Insert dialog; choose Entire row to insert a worksheet row.
The fastest Windows shortcut
The keyboard shortcut is often written as Ctrl++, meaning hold Ctrl and press the plus key. On many keyboards, plus shares the equals key, so you press Ctrl+Shift+=. The exact physical keys can depend on your keyboard layout, but the command is the same: insert the selected cells, row, or column.
For a full worksheet row, first select its row heading—the numbered box at the far left—then use the shortcut. For example, select row heading 8 and press Ctrl+Shift+=; Excel adds a blank row above row 8, and the old row 8 moves down. This is useful when entering a missing record in a list, adding space between sections, or making room for a new line in a worksheet.
There is also a ribbon key sequence on Windows: press Alt, then H, I, and R, one after another. These are Key Tips for Home, Insert, and Insert Sheet Rows. They are not meant to be held down together. This route inserts a worksheet row at the active cell’s position and is handy if you do not remember the plus-key combination.
Insert a row step by step
For a predictable result, select the row heading before using the shortcut. This makes it clear that you intend to insert an entire row, rather than shift a few cells and risk misaligning nearby data.
- Find the row number where the blank row should appear.
- Click that row’s heading on the left edge of the worksheet. The whole row should be highlighted.
- Press
Ctrl+Shift+=on a typical Windows keyboard. - Check that the blank row appeared above the selected row, then enter or paste the new information.
You can select the row heading with the keyboard too. Click a cell in the target row and press Shift+Space to select its entire worksheet row; then press the insert shortcut. If you use this method while editing a cell, press Enter or Esc first to leave edit mode. Otherwise, Excel may interpret the keys as part of the cell’s contents instead of as a worksheet command.
Why selection changes the result
Excel interprets the insert command according to what is selected. A selected row heading tells Excel to insert a whole row. A selected cell or block of cells is less specific, so Excel normally displays the Insert dialog. That dialog offers choices such as shifting cells down, shifting cells right, inserting an entire row, or inserting an entire column.
This distinction matters in a formatted worksheet. If you select only one cell and choose to shift cells down, Excel moves just that cell and the cells below it in the selected column. It does not create a full-width worksheet row. Neighboring columns can then stop lining up with the moved values. When the goal is a new record across several columns, select the row heading or choose Entire row in the dialog.
Excel inserts the new row above the selected row, not below it. To add a row below row 8, select row 9 and insert. If row 9 contains data, that data moves down; the new blank row takes its place. Remembering this above-the-selection rule prevents the common mistake of inserting on the wrong side of a heading or subtotal.
Insert several rows at once
You do not have to repeat the shortcut separately for every new row. Select as many adjacent row headings as the number of rows you want to add, then run the insert command once. For instance, selecting row headings 5, 6, and 7 and inserting creates three blank rows above the first selected row. Existing worksheet rows move down together.
To select adjacent rows, drag across their row headings, or click the first heading and Shift-click the last. You can also select the first row heading, hold Shift, and use the arrow keys to extend the selection. Then press Ctrl+Shift+=. This approach is more efficient and less error-prone than inserting one row repeatedly, especially when preparing a template or adding several records in the middle of a list.
Make sure the number of selected row headings matches the number of rows you intend to add. Selecting a block of cells instead of complete row headings may bring up the Insert dialog and offer to shift only those cells. For a full-width insertion, the row numbers themselves should be highlighted.
Ribbon and mouse alternatives
If you prefer menus, select the target row and use Home > Insert > Insert Sheet Rows. You can also right-click a row heading and choose Insert. Both methods insert a worksheet row above the selected row. The ribbon is especially useful when a keyboard layout makes the plus shortcut awkward or when you want to confirm the exact command before applying it.
When a cell is selected rather than a row heading, the Home tab’s Insert menu may offer an insert-cells choice as well as commands for sheet rows and columns. Choose Insert Sheet Rows when you need a complete worksheet row. If the Insert dialog appears, select Entire row and confirm. The dialog is not an error; it is Excel asking how broadly the insertion should apply.
These methods create the same kind of worksheet row. Choose the shortcut for speed, the ribbon when you want the command spelled out, or the right-click menu when the row heading is already selected. The key practical point is to check what is selected before you insert.
Rows in Excel tables are a special case
An Excel table is a structured range with its own headers, filters, and table formatting. If your active cell is inside a table, inserting a worksheet row can affect the surrounding worksheet as well as the table. When you specifically want a new table record, use the table-aware option: right-click a cell in the table row near the intended position and look for Insert > Table Rows Above. The wording and available choices depend on the selected table area.
For adding a record at the bottom of a table, another simple option is to click the last cell in the last table row and press Tab. Excel creates a new table row when you tab out of that final cell. This extends the table itself and carries its table formatting and calculated-column behavior into the new record. It is not the same as inserting a blank worksheet row above an existing row.
If the shortcut appears to affect the wrong part of a table, undo immediately with Ctrl+Z, inspect the selection, and choose the table-row command if a table record was your goal. Distinguishing table rows from worksheet rows helps avoid accidentally shifting titles, notes, or totals outside the table.
Using Excel on Mac or in a browser
On Excel for Mac, the plus-key shortcut can depend on the keyboard layout. The row-selection principle is unchanged: select the row heading, then use the insert-rows command. A commonly used Mac equivalent for the insert shortcut is Control+Shift+=, but if that combination does not work on your keyboard, use the ribbon command Home > Insert > Insert Sheet Rows or right-click the row heading and choose Insert. Avoid assuming that the Windows Alt Key Tip sequence is identical on Mac.
Excel for the web also provides row insertion through the Home tab and the row-heading context menu. Browser and operating-system shortcuts can overlap with Excel commands, so the ribbon or context menu is a dependable fallback if the keyboard combination is intercepted or behaves differently. As with desktop Excel, select a complete row when the intention is to insert a full worksheet row.
Common problems and quick fixes
- The Insert dialog opens: You probably selected a cell or cell range, not a complete row. Choose Entire row, or cancel and select the row heading first.
- The shortcut types a character or does nothing: Check that you are not editing a cell, and verify which key produces the plus sign on your keyboard. On many layouts, that means holding Shift while pressing equals.
- The new row appears in the wrong place: Excel inserts above the selected row. Select the row below the position where the blank row should go.
- The data no longer lines up: You may have shifted cells instead of inserting an entire row. Undo with
Ctrl+Z, select the row heading, and insert again. - You cannot insert a row: The worksheet may be protected, or the workbook may restrict editing. Check the Review tab for protection controls and ask the workbook owner for permission if needed.
Before inserting rows in a large or shared worksheet, check nearby formulas, merged cells, and totals. Excel generally adjusts many formulas when rows are inserted, but a worksheet can contain manually written references or layout choices that need review. If you are unsure, save a copy first or use Undo immediately if the result is not what you expected.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
On Windows, select a row heading and press Ctrl+Shift+=, often described as Ctrl++. A row is inserted above the selected row.
How do I insert a row without a mouse?
Click a cell in the target row, press Shift+Space to select the whole row, then press Ctrl+Shift+= on Windows. The new row appears above that row.
How do I add a row below the current row?
Select the row heading immediately below the intended position and insert. Excel places the blank row above the selection, so the existing data in the selected row moves down.
Can I insert multiple rows at once?
Yes. Select the same number of adjacent row headings as the number of rows you want, then use the insert command once. Excel adds that many 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 range rather than a complete row. Select the row number at the left, or choose Entire row in the dialog.
Does the shortcut work the same way on Mac?
The insert command is available on Mac, but the keyboard combination can vary with the keyboard layout. Try Control+Shift+= with a row selected, or use Home > Insert > Insert Sheet Rows for a clear menu route.
Related
- Solver in Excel: Where to Find It and How to Enable It
- Excel Solver Parameters: How to Set Them Correctly
- Excel Slicers for Multiple Tables: What Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Text to Value: Convert Numbers Stored as TextTo turn numeric text into a real Excel number, select the cells and choose Convert to Number from…
- Excel Data Validation Lists: Setup, Tips, and FixesYes. Excel has data validation lists, which add a drop-down menu to a cell so people can choose…
- How to Share a Group Calendar in Outlook 365 With MembersTo share a Microsoft 365 group calendar in Outlook, add the people who need access as members of…
- How to Import CSV to Excel: Steps and Common FixesTo import a CSV into Excel for Microsoft 365 on Windows, choose Data > Get Data > From…
- XLOOKUP in Google Sheets: Formula, Examples & TipsGoogle Sheets has an XLOOKUP function for finding a value in one range and returning the corresponding value…
- How to Duplicate an Excel Document on Windows SafelyTo duplicate an Excel document on Windows, open it in Excel and choose File > Save As >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.