In Excel for Microsoft 365 on Windows, select the row where the new row should go, then press Ctrl+Shift+= (the plus sign on the equals key). Excel inserts a blank row above the selected row. If you have selected only a cell, the shortcut opens an Insert dialog instead; select Entire row there.
The Excel laptop shortcut and what it does
The usual Windows shortcut is written as Ctrl+Shift++ or Ctrl+Shift+Plus. On most laptop keyboards, the plus sign shares the equals key, so hold Ctrl and Shift and tap that key. You do not need a separate number pad. The key combination is for inserting, not deleting, a worksheet row.
Excel inserts the new row above the selected row and shifts existing rows downward. For example, if row 8 is selected, a blank row appears at row 8 and the previous row 8 becomes row 9. The shortcut does not place a row beneath the selection. To add one below a particular row, select the next row first; if that row contains important data, Excel shifts it down to make room.
Selection matters because Excel can insert different things depending on what is selected. Selecting an entire worksheet row tells Excel to insert a worksheet row. Selecting one cell asks Excel what kind of cells to insert, so the Insert dialog appears. This distinction is the main reason the shortcut may seem to behave differently from one attempt to the next.
Select a full row before using the shortcut
The most reliable method is to select the row by its number at the left edge of the worksheet. Click the row heading, such as 8, and then press Ctrl+Shift+=. The row heading should highlight across the sheet, indicating that the whole worksheet row—not just the cell you last edited—is selected.
If you prefer to keep your hands on the keyboard, click a cell in the row and press Shift+Space to select that entire row. Then press Ctrl+Shift+=. For example, click a cell in row 12, press Shift+Space, and then use the insert shortcut to create a blank row 12. The existing contents of row 12 move down to row 13.
- Click any cell in the row that should move down.
- Press Shift+Space, or click the row number to select the full row.
- Press Ctrl+Shift+=. On a standard laptop keyboard, hold Ctrl and Shift while tapping the equals/plus key.
- Check that the blank row appears above the selected row before entering data.
When you select the row number, Excel highlights the whole worksheet row, including cells beyond the visible columns. This is useful when a sheet has data or formatting far to the right. Selecting a row is also clearer than selecting only the cells that currently look occupied, since a worksheet row can contain formulas or formatting outside the visible data block.
What happens when you select only a cell
If you click a single cell and press Ctrl+Shift+=, Excel may open the Insert dialog rather than immediately adding a complete worksheet row. This is expected: inserting cells can mean shifting cells right, shifting them down, inserting an entire row, or inserting an entire column. Choose Entire row and confirm to insert a worksheet row above the row containing the active cell.
This dialog is useful when you want to change only part of a grid rather than move every cell across the worksheet. However, shifting a small block of cells can misalign related data in neighboring columns. If each record spans several columns—such as a customer name, date, and amount—insert a whole worksheet row so those fields stay together.
A common misunderstanding is that the shortcut always inserts a row wherever the cursor is. It inserts based on the current selection. If you are editing text inside a cell, first finish or cancel that edit, then select the row. If you accidentally insert cells rather than a whole row, use Undo immediately and repeat the operation with the row selected.
Insert several blank rows at once
You can insert multiple rows in one operation. Select the same number of existing worksheet rows as the number of blank rows you need, then press Ctrl+Shift+=. Excel inserts that many rows above the top row in the selection. For instance, select rows 5 through 7 and use the shortcut to insert three blank rows starting at row 5. The original rows 5 through 7 move down.
To select a range with the keyboard, select a cell in the first row, press Shift+Space to select that row, then extend the selection to additional rows with Shift and the Up or Down Arrow. You can also drag across row headings or click the first row number and Shift-click the last one. Confirm that the highlighted selection covers the intended number of complete rows before inserting.
For a large number of rows, count carefully before acting. Inserting 20 rows when you meant to add two can displace data and affect formulas, print areas, or references. Undo with Ctrl+Z if the result is wrong and the workbook has not undergone another action that changes what Undo will reverse. In a shared or complex workbook, check key totals and formulas after structural changes.
Use the ribbon or right-click menu instead
If the laptop keyboard layout makes the shortcut awkward, Excel provides menu options. Select the row or rows, then choose Home > Insert > Insert Sheet Rows. This explicitly inserts complete worksheet rows and is a dependable alternative when you cannot identify the plus key or a shortcut is intercepted by another application.
You can also right-click a selected row heading and choose Insert. When several row headings are selected first, this inserts the same number of rows above them. Right-clicking a cell instead may offer options for inserting cells, so select the row heading if you want an unambiguous whole-row operation.
These options do the same basic job as the keyboard shortcut; they are not a different kind of row. The ribbon is helpful when teaching the operation or troubleshooting, because the command spells out that it inserts sheet rows. The shortcut is faster for repeated edits once you are comfortable selecting the right rows.
Rows inside Excel tables and formatted data
A worksheet row and a table row are related but not identical. Excel tables have their own headers, filters, and structured data area. If you insert a worksheet row within a table, the table may expand to include it, depending on where you insert. That can be useful when adding a new record, since table formatting and calculated-column formulas may extend automatically.
For a new record at the bottom of a table, you often do not need to insert a row above existing records. Click the last cell in the table and press Tab to move to a new row, or type in the row directly below the table so Excel can extend it. If you specifically need a blank row within the table, select the relevant table row and use the table’s insert option or the worksheet-row shortcut, then check that the table boundaries and formulas remain as intended.
In ordinary ranges, inserting a full row shifts all cells below it downward. Excel usually adjusts formulas that refer to affected cells, but not every workbook structure reacts identically. External links, formulas using indirect references, named ranges, charts, and macros may have their own behavior. For a critical workbook, save a copy before making many structural edits and review dependent calculations afterward.
Laptop keyboard layouts, Mac, and Excel for the web
On many Windows laptops, the plus sign is produced by holding Shift and pressing the equals key. That is why instructions may display the shortcut as Ctrl+Shift+= even though people describe it as Ctrl+Shift+Plus. Use the key that produces + on your keyboard; do not look for a dedicated plus key on a numeric keypad. Keyboard layouts differ, so a non-US layout may place the symbol elsewhere.
In Excel for Mac, select the full row and try Control+Shift+=; the physical key that produces the plus sign depends on the keyboard layout. Mac shortcut behavior can vary with keyboard settings and Excel version, so the reliable fallback is to select the row and use Home > Insert > Insert Sheet Rows. Do not assume the Windows Ctrl key should be replaced with Command for this operation.
Excel for the web may also respond differently because browser shortcuts can compete with spreadsheet shortcuts, and behavior can depend on the browser and selection. If the keyboard combination does not insert a row there, select the row heading and use the Insert command from Excel’s ribbon or context menu. The row-selection principle remains the same: select the complete worksheet row to avoid a dialog for shifting only cells.
Common shortcut problems and fixes
If nothing happens, check the selected object and keyboard focus before repeating the shortcut. A cell may still be in edit mode, the active window may not be Excel, or a laptop utility or browser may be intercepting a key combination. Try clicking a row heading and using the ribbon command; if that works, the issue is likely the key sequence or focus rather than the worksheet.
- The Insert dialog appears: You selected a cell rather than a full row. Choose Entire row, or cancel, select the row heading, and try again.
- Excel inserts cells in the wrong direction: Undo, select the entire worksheet row, and repeat. Avoid choosing Shift cells down when records span several columns.
- The wrong row moves: Excel inserts above the selection. Select the row currently occupying the position where the new blank row should begin.
- The key combination types a plus sign: You may still be editing a cell, or the modifier keys were not held together. Press Enter or Esc to leave edit mode, select the row, and retry.
- The shortcut is unavailable: Use Home > Insert > Insert Sheet Rows or right-click the row heading and choose Insert.
After inserting, verify a recognizable value in the rows above and below the new blank one. In a structured data sheet, check that formulas, totals, filters, and table formatting still cover the intended records. This quick check can catch an insertion made in the wrong position before you continue editing.
Frequently Asked Questions
What is the shortcut to insert a row in Excel on a laptop?
In Excel for Microsoft 365 on Windows, select the full row and press Ctrl+Shift+=, which is the plus sign on most laptop keyboards. The new row appears above the selected row.
How do I insert a row above in Excel?
Select the row number where the blank row should appear, then use Ctrl+Shift+=. You can also choose Home > Insert > Insert Sheet Rows. Excel inserts above the selected row, not below it.
Can I insert multiple rows with one shortcut?
Yes. Select as many complete worksheet rows as you want to add, then press Ctrl+Shift+=. Excel inserts the same number of blank rows above the selection.
Why does Excel show an Insert dialog instead of adding a row?
The selection is probably a cell rather than a complete row. Choose Entire row in the dialog, or cancel it and select the row heading before using the shortcut.
Does Ctrl+Shift+= work in Excel for Mac?
It may work as the insert shortcut, with the exact plus key depending on the keyboard layout. If it does not, select the row and use Home > Insert > Insert Sheet Rows.
Related
- Ungroup Worksheets in Excel: Shortcut and Quick Fixes
- Ungroup Cells in Excel: Keyboard Shortcut and Steps
- How to Ungroup Excel Windows on the Windows 11 Taskbar
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets VLOOKUP: Link Two Sheets Step by StepTo look up a value in a different Google Sheets file, combine VLOOKUP with IMPORTRANGE: allow access to…
- Excel Shortcut to Go to a Cell: F5, Ctrl+G, and MoreIn Excel for Microsoft 365 on Windows, press F5 or Ctrl+G to open the Go To dialog, type…
- Excel CSV Import Options: Which Method to UseIn Excel for Microsoft 365 on Windows, the most controlled way to import a CSV is Data >…
- Google Sheets Filter Just for Me? Use Filter ViewsYes. In Google Sheets, use a filter view to sort or narrow rows for your own view without…
- How to Make a Color Key in Excel for Clearer SheetsTo make a color key in Excel, set aside a small area of the worksheet, add a labeled…
- GST Number to PAN in Excel: Extract the 10-Character PANTo extract the PAN from a GST number in Excel, place the GSTIN in A2 and enter =MID(A2,3,10)…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.