In Excel for Microsoft 365 on Windows, select the row you want to work around and press Ctrl+Shift+= to insert a row above it, or Ctrl+- to delete the selected row. To select a worksheet row first, click its numbered heading or select a cell in it and press Shift+Space.
The Windows Shortcuts at a Glance
The shortcuts operate on the current selection, so selecting a full row is the most reliable way to insert or remove a full worksheet row. A plus sign may be shown in shortcut guides as Ctrl++; on a standard keyboard, the plus key is usually typed with Shift, which is why the key sequence is commonly written Ctrl+Shift+=.
- Select the current row: Click a cell in it and press Shift+Space, or click the row number at the left edge of the sheet.
- Insert a row above: With the row selected, press Ctrl+Shift+=.
- Delete a row: With the row selected, press Ctrl+-.
- Undo the last change: Press Ctrl+Z, provided the action is still in the undo history.
For example, to add space above row 12, select any cell in row 12, press Shift+Space, and then press Ctrl+Shift+=. Excel inserts a blank row at row 12 and moves the former row 12 and the rows below it down. To remove row 12, select it and press Ctrl+-; the rows beneath move up. These are different from merely clearing cell contents: deleting a row removes the row from the sheet structure.
Insert a Row with the Keyboard
Use this sequence when you want an entire worksheet row rather than a few cells shifted down:
- Click a cell in the row that should end up below the new blank row.
- Press Shift+Space to select the whole worksheet row. Check that the row number is highlighted.
- Press Ctrl+Shift+=. The new blank row appears above the selected row.
You can select several adjacent row numbers before using the shortcut. Excel inserts the same number of rows above the selection. For instance, select rows 8 through 10 and use the insert shortcut to add three blank rows above row 8. The existing rows shift down; they are not overwritten. This is useful when you know the required number of rows in advance, such as making room for three new records in a list.
If you select a single cell instead of the whole row, Excel may open the Insert dialog, which offers choices such as shifting cells down or inserting an entire row. That dialog is helpful when you want to make space in only part of a range, but it is an extra step and can have a different effect on nearby data. Selecting the row heading, or using Shift+Space, makes your intent clear.
Delete a Row with the Keyboard
To remove a row, select it with Shift+Space or click its row number, then press Ctrl+-. If the selection is a full worksheet row, Excel deletes that row and moves the content below it upward. This is a structural deletion: formulas, formatting, and other cell contents in the deleted row are removed along with the row itself.
If only a cell or small range is selected, Ctrl+- opens a dialog that asks how to shift surrounding cells. Choose Entire row if you mean to remove the whole worksheet row. Choosing Shift cells up instead removes only the selected cells and pulls cells from below into their place, which can misalign a table of records. When information in neighboring columns belongs together, deleting the full row is generally the safer choice.
Be especially careful when a row contains formulas, notes, or data used elsewhere in the workbook. Excel typically adjusts many references when rows are deleted, but check important formulas and linked ranges afterward. If you delete the wrong row, use Ctrl+Z immediately. Undo is preferable to trying to reconstruct the deleted contents manually.
Insert or Delete Several Rows
You do not have to repeat the shortcut one row at a time. Select the number of existing rows that matches the number you want to add, then insert. For example, selecting rows 20 through 24 and pressing Ctrl+Shift+= inserts five rows above row 20. To delete several adjacent rows, select all of their row headings and press Ctrl+- once.
For a nonadjacent selection, deleting selected row headings can remove multiple separated rows, but take a moment to verify the highlighted selection before confirming the action. When inserting, a contiguous block is usually easier to reason about: the count of selected rows determines how many rows Excel adds. If the result is not what you intended, Ctrl+Z can reverse the insertion or deletion as long as you have not lost the relevant undo state.
Working with Excel Tables
An Excel Table is a formatted data range with features such as filter buttons and automatically expanding columns. A table row is not quite the same thing as a whole worksheet row, so use care if the data is part of a table. To add a record within a table, you can often move to the last cell of the last table row and press Tab; Excel creates a new table row. To insert above a particular table record, right-click a cell in that table row and choose Insert, then the table-row insertion option shown in the menu.
To remove a table record without deleting unrelated cells across the worksheet, right-click within the table row and choose Delete followed by the option for table rows. The exact wording can depend on the selection and Excel build. Deleting a whole worksheet row from the row heading is broader: it affects every column on that worksheet row, including content outside the table. If adjacent columns contain separate information, remove the table row rather than the entire sheet row.
Tables can expand when you type directly beneath them, but that behavior is not a substitute for choosing the right deletion command. If the goal is to remove a record while preserving the table structure, use the table-specific row command. If the goal is to remove an unused worksheet row everywhere, select the worksheet row and use the normal delete shortcut.
Windows, Mac, and Excel for the Web
The shortcuts above are for Excel for Microsoft 365 on Windows. On a Mac, the equivalent insert and delete key combinations are generally Control+Shift+= and Control+- after selecting the row. Mac keyboards and Excel shortcut settings can affect which physical key produces a symbol; if a combination does not work, use the ribbon or the row-heading context menu. Do not automatically replace Ctrl with Command: many Excel keyboard shortcuts differ from the usual Mac app convention.
Excel for the web runs in a browser, where some key combinations can overlap with browser commands or vary with the keyboard layout. If the shortcut is intercepted or does not behave as expected, select the row heading and use the Home tab’s Insert or Delete command, or right-click the row heading and choose the appropriate command. Menu labels and available options can vary slightly between desktop and web versions, but selecting a row heading before acting keeps the scope clear.
Shortcut, Ribbon, or Context Menu?
The keyboard shortcut is fastest for repeated edits, especially when moving through a worksheet with the keyboard. The row-heading menu is more discoverable and can help prevent a mistaken cell-only operation. The ribbon is useful when you prefer visible commands or when a keyboard shortcut conflicts with another application.
- Keyboard: Select the row and press Ctrl+Shift+= to insert or Ctrl+- to delete on Windows.
- Ribbon: Select a row, then use Home > Insert or Home > Delete. The command applies according to the selection.
- Context menu: Right-click the row number and choose Insert or Delete.
All three approaches can produce the same worksheet-row result when the full row is selected. The important distinction is not which control you use but what is selected when you use it. If only one cell is selected, Excel may insert or delete cells rather than an entire row.
Common Problems and Safe Checks
If Ctrl+Shift+= opens a dialog instead of inserting a complete row, check whether you selected a cell rather than the row heading. Press Esc to close the dialog, then select the row with Shift+Space and try again. Similarly, if Ctrl+- asks how to shift cells, choose Entire row only when removing the full worksheet row is intended.
A few practical checks reduce the chance of damaging a busy sheet:
- Confirm the row number or highlighted area before pressing Delete.
- Check whether the selection is inside an Excel Table; use the table-row command when only a table record should be removed.
- Look across the full row before deleting it, since unrelated information may be farther to the right than the visible data.
- For important workbooks, save before making a large batch of structural changes.
- Use Ctrl+Z promptly if the result is wrong, then verify the restored rows and formulas.
One common misconception is that pressing the Delete key deletes a worksheet row. It usually clears the contents of selected cells; it does not remove the row itself. To remove the row structure, use Ctrl+- with the row selected, or use the Delete command on the row heading. Conversely, clearing a row’s contents can be exactly what you want if you need to retain the layout, formatting, or row position.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
On Windows, select the row above which the new row should appear, then press Ctrl+Shift+=. Select the row first with Shift+Space or by clicking its row number.
What is the shortcut to delete a row in Excel?
Select the full row and press Ctrl+-. If you have selected only cells, Excel may show a dialog; choose Entire row only if you intend to remove the whole worksheet row.
How do I insert multiple rows at once?
Select as many existing row headings as the number of rows you want to add, then press Ctrl+Shift+=. Excel inserts that many rows above the first selected row.
Does the Delete key remove a row?
No. The Delete key generally clears contents from selected cells. To remove a worksheet row, select its row heading and use Ctrl+- or the row’s Delete command.
Can I undo an inserted or deleted row?
Usually, yes: press Ctrl+Z soon after the action. If you have performed later actions, undo may also reverse those actions, so check the worksheet after using it.
Related
- How to Sum in Excel Using the Keyboard: Quick Steps
- How to Sum in Excel Without Hidden Rows Using SUBTOTAL
- Sum in Excel From Different Sheets: A Step-by-Step Guide
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 Box Linked to Cell: Setup, Uses, and FixesYes. In Excel for Microsoft 365 on Windows, select the text box by its outer border, click the…
- Excel Page Break Preview: How to View and Adjust PagesExcel Page Break Preview shows how a worksheet will be divided into printed pages. In Excel for Microsoft…
- How to Autofit Rows in Excel With a Keyboard ShortcutIn Excel for Microsoft 365 on Windows, select the row or cells you want to adjust, then press…
- How to Check for Duplicate Data in ExcelTo check for duplicate values in Excel, select the cells you want to inspect and choose Home >…
- Power Query Reference: What It Does and When to Use ItIn Excel Power Query, a reference is a new query built from the result of an existing query.…
- Google Sheets Duplicate Values: Find and Remove ThemYes, Google Sheets can find duplicate values, highlight them, and remove duplicate rows. In a browser, use Format…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.