In Excel for Microsoft 365 on Windows, select the row by its row number, press Ctrl+X, select the row number where the cut row should go, then press Ctrl+Shift+= (the plus-key shortcut). Excel inserts the cut row above the selected row and shifts existing rows down; do not use Ctrl+V if you want to insert rather than replace cells.
The Windows shortcut, step by step
The key detail is to select a whole worksheet row at both ends of the operation. Clicking the row number at the left edge of the grid selects every cell in that row, including cells beyond the visible columns. Then use this sequence:
- Click the number of the row you want to move. To select several adjacent rows, drag across their row numbers or select the first and Shift-click the last.
- Press
Ctrl+X. A moving dashed outline appears around the cut selection, indicating that Excel is ready to move it. - Click the row number above which the moved row should be inserted. For example, select row 5 to place the cut row immediately before the current row 5.
- Press
Ctrl+Shift+=. On a standard keyboard, the equals key shares the plus symbol, so hold Ctrl and Shift while pressing that key.
The selected destination row is not replaced. Excel inserts the cut row there and moves the former destination row, along with the rows below it, down by one. If you cut multiple complete rows, the same operation inserts the group above the destination and keeps the rows in their original order.
What “insert a cut row” means
Cutting and inserting is a move, not a copy-and-paste operation and not simply deleting the original row. Excel removes the selected row from its old position and places it at the new one, shifting other worksheet rows to make room. Values, formulas, cell formatting, and other row content move together. Formulas elsewhere in the workbook may adjust their references as Excel updates the sheet structure.
That differs from pasting a cut row over a destination. A normal paste can replace existing cells in the destination area; inserting the cut row instead preserves the destination data by pushing it down. It also differs from inserting a blank row: a blank row adds space but does not move the selected data into it. This distinction matters when reorganizing a schedule, sorting a hand-built list, or relocating a record without losing the row currently occupying the destination.
How to choose the destination row
Excel inserts the cut row above the selected destination row. If a list has headings in row 1 and you want a moved record to appear between the current rows 4 and 5, select row 5 before using the insert shortcut. Selecting row 4 would place it above row 4 instead. This “above the selection” rule is an easy detail to overlook when working quickly.
To move a row to the bottom of a list, select the first empty row immediately below the list. For instance, if records occupy rows 2 through 20, select row 21 and insert the cut row there. Excel will place the moved record at that position. If the sheet contains unrelated data farther down, avoid selecting a row based only on the visible list; inserting a complete worksheet row affects the entire sheet, not just the columns in the list.
Selecting a whole row versus part of one
Clicking a row heading selects the entire worksheet row. You can also select a cell in the row and press Shift+Space to select the row using the keyboard. That is useful when navigating a large sheet: move to a cell in the row, press Shift+Space, and then cut with Ctrl+X.
If you select only a range of cells and cut it, the insertion shortcut may apply to that range rather than moving a complete worksheet row. Excel may show an Insert dialog asking whether to shift cells down or right. For a complete-row move, use the row heading or Shift+Space before cutting, and select the destination row heading before inserting. This avoids shifting only part of a table and leaving neighboring columns out of alignment.
Keyboard shortcut and menu alternatives
The shortcut is fast, but the context menu makes the action more visible and can be easier to verify. After selecting and cutting the row, right-click the destination row number and choose Insert Cut Cells. The command is relevant when Excel has a cut selection available; if you copied the row instead of cutting it, the menu wording and available actions can differ. The menu approach performs the same insertion above the selected row.
You can also use the ribbon when inserting a blank row rather than moving cut data: select a row, then choose Home > Insert > Insert Sheet Rows. That command creates an empty row and shifts existing rows down; it does not place the cut row there by itself. For the cut-row operation, use Ctrl+Shift+= after selecting the destination, or use Insert Cut Cells from the right-click menu.
Excel for Mac and Excel for the web
In Excel for Mac, use Command+X to cut the selected row. The insert shortcut is generally Control+Shift+= on a Mac keyboard, with the same instruction to select the destination row first. Keyboard layouts and Excel settings can affect shortcuts, so if that combination does not perform the insertion, right-click the destination row heading and choose Insert Cut Cells when available.
In Excel for the web, keyboard shortcuts can depend on the browser and on whether the browser or Excel receives the keystroke. The row-heading context menu is a practical alternative: cut the row, right-click the destination row heading, and look for the insert-cut command. If your browser intercepts a shortcut, use the on-screen menu instead. In every version, verify that the entire row is selected and that you are inserting above the intended destination.
Common problems and how to fix them
- The destination data disappears or gets replaced: You likely pasted with
Ctrl+Vrather than inserting the cut cells. Undo immediately withCtrl+Zif the result is wrong, then repeat using the insert shortcut or the Insert Cut Cells command. - Excel opens an Insert dialog: The source or destination selection may be a cell range rather than a complete row. Cancel, select the row heading at both stages, and try again. The dialog is normal when inserting a partial selection, but it is not the clearest route for moving an entire row.
- The row appears in the wrong place: The destination is the row above which Excel inserts. Undo, select the correct destination row number, and repeat.
- The cut outline has disappeared: A new copy or cut action, pressing Esc, or another clipboard operation may cancel the pending cut. Select and cut the source row again before inserting.
- The command is unavailable: Check that a row is still marked as cut and that the destination selection is compatible. Protected sheets can restrict inserting or deleting rows; you may need permission or to unprotect the sheet before changing its structure.
Working inside an Excel table
Excel tables have their own structured boundaries and filtering behavior, so moving a record inside a table deserves an extra check. Selecting the worksheet row number selects the entire sheet row, not just the table record. Inserting a whole worksheet row can therefore affect material in other columns on that same row and can alter the layout around the table.
If the goal is only to reorder one record within a table, select and move the table’s cells or use the table’s sorting controls where appropriate, rather than assuming the entire worksheet row is isolated. Check that the row remains within the table after the move and that calculated columns, totals, and filters still behave as expected. For a small table, dragging a selected row is tempting, but cut-and-insert is more explicit and reduces the risk of dropping data into an unintended position.
Undo, formulas, and a safe workflow
Excel normally lets you undo a mistaken row insertion with Ctrl+Z, provided you have not taken an action that clears the undo history. If the result is unexpected, undo before making other edits. Then confirm the source row and destination, and repeat. Undo is a convenient safeguard, but it is not a substitute for checking a workbook that contains important data or complex formulas.
Moving a row can change how formulas refer to cells, particularly when formulas point to the moved data or when the move changes the order of records used in calculations. Before reorganizing a report, note any sorts, filters, named ranges, or formulas that depend on row positions. For critical workbooks, save a copy first and inspect key totals or formulas after the move. The shortcut moves worksheet content; it does not guarantee that the workbook’s logic still matches the new row order.
Frequently Asked Questions
What is the shortcut to insert a cut row in Excel?
On Windows, cut the selected row with Ctrl+X, select the destination row heading, then press Ctrl+Shift+=. Excel inserts the cut row above that destination.
Does Excel insert the cut row above or below the selected row?
It inserts above the selected destination row. To put a row at the end of a list, select the first empty row below the list.
Can I use Ctrl+V to insert a cut row?
Use the insert shortcut or Insert Cut Cells instead. Ordinary paste can replace cells at the destination rather than shifting the existing row down to make space.
How do I select a complete row without clicking its number?
Click a cell in the row and press Shift+Space. Then press Ctrl+X on Windows and select the destination row before inserting.
What is the Mac shortcut for inserting a cut row?
Cut with Command+X, select the destination row, and try Control+Shift+=. If the keyboard shortcut differs on your setup, use the destination row’s right-click menu and choose Insert Cut Cells.
Related
- Excel ODS vs CSV: Which Format Should You Use?
- Excel Number of Workdays Between Dates: How to Calculate
- Excel Savings Plan Template: Build a Monthly Goal Tracker
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Most Used Excel Shortcut KeysThe most used Excel shortcut keys on Windows are Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to…
- How to Hyperlink in Excel for the Web, Step by StepTo add a hyperlink in Excel for the web, select a cell, choose Insert > Link (or press…
- How to Share a Google Sheets Link and Control AccessTo share a Google Sheets link, open the sheet in a browser, select Share, choose who can access…
- How to Enter a Timestamp in Google Sheets: 3 MethodsTo enter a fixed timestamp in Google Sheets, select a cell and press Ctrl+Alt+Shift+; on Windows; use =NOW()…
- Google Sheets Dropdown From Range: Setup, Options & FixesYes. In Google Sheets, select the cells that need a dropdown, choose Data > Data validation > Add…
- Excel Dropdown List Color Change: What You Can Do InsteadExcel cannot change the color of individual choices inside a standard data-validation dropdown. You can, however, use conditional…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.