Move a Row Up or Down in Excel Without Losing Data

To move a row in Excel without overwriting another one, click its row number, press Ctrl+X, then right-click the row where it should go and choose Insert Cut Cells. To move a row by dragging, select its row number and drag the selection border while holding Shift. Save a copy first if the worksheet is important, and check whether your data is in a formatted Excel Table, since table rows are often best reordered with sorting.

What You’ll Need

A worksheet you can edit. If the sheet is protected, you may need permission or its password before changing row positions.
The row you want to move and a clear idea of the row it should sit above or below.
For important workbooks, a saved backup or a recent saved version to return to if the result is unexpected.
On Windows, use Ctrl+X to cut and Ctrl+Z to undo. On Mac, use Command+X and Command+Z. The menu and mouse steps below are similar in Excel for Mac, though names and context-menu placement can vary slightly.

Step-by-Step

Check what kind of data you have. If the range is an ordinary worksheet list, use one of the move methods below. If it is an Excel Table, identified by filter arrows in its header and a Table Design tab when selected, see step 6 for a safer way to change its order. If a filter is active, clear it before rearranging entire worksheet rows so hidden records do not surprise you. Click Data > Clear in the Sort & Filter group, or turn off the filter, then confirm that all records are visible.
Identify the complete row and its destination. Look at the row numbers along the left edge of the worksheet. Decide whether you need to move the entire worksheet row, including its cells outside the visible list, or only a set of cells inside a table. Moving an entire row affects every column on that worksheet. If other information is stored far to the right, it will move too. Make sure that is what you intend before selecting the row.
Select the row you want to move. Click its numbered row header at the far left. The whole worksheet row should become highlighted. To select several neighboring rows, drag down or up across their row numbers, or select the first row header and Shift-click the last one. Avoid selecting a single cell if you mean to relocate the entire row; doing so can move only part of your data and leave records misaligned.
Move the row with Cut and Insert Cut Cells. With the row selected, press Ctrl+X on Windows or Command+X on Mac. Excel marks the row with a moving dashed outline. Right-click the row number where the cut row should be inserted, then choose Insert Cut Cells. The cut row is placed at that position and the other rows shift to make room, rather than being overwritten. For instance, to put a row immediately above a particular record, right-click that record’s row number. To put it just below a record, insert it before the next record. If you are moving a row to the bottom of a list, insert it before the first blank row below the list.
Use Shift-drag for a quick move. Select the row by clicking its row number. Point to the border of the highlighted selection until the move pointer appears. Hold Shift, then drag the row border to the position where you want the row inserted. Watch for the horizontal insertion indicator between rows; release the mouse only when it is at the intended boundary, then release Shift. If you drag without Shift, Excel may replace existing cells instead of inserting the row. If the pointer or insertion indicator is unclear, cancel and use Cut and Insert Cut Cells instead.
Reorder a row inside an Excel Table. For a table, avoid moving an entire worksheet row if it contains unrelated information outside the table. A dependable option is to add a temporary column called Order, number the table records in their current sequence, and change the numbers to represent the new sequence. For example, if two adjacent records need to swap, exchange their Order values. Click a cell in the table and choose Data > Sort; sort by Order from smallest to largest. Check that the records appear as intended, then remove the temporary column if you no longer need it. Keep the Order values unique so the sort result is unambiguous. If filters are applied, make sure you understand whether you are sorting the whole table or only the displayed records.
Check the result and save. Confirm that the moved row is in the right place and that its values still line up under the correct headings. Check nearby rows, totals, formulas, and any notes or formatting that matter. If the result is wrong, use Ctrl+Z on Windows or Command+Z on Mac immediately, then try again. When the arrangement is correct, save with Ctrl+S or Command+S.

Common Mistakes

Dragging without holding Shift. Dragging a selection by its border can replace the contents at the destination. For a move that inserts cells and shifts other rows, keep Shift held during the drag and watch for the insertion line. If you are not certain what Excel is about to do, use Insert Cut Cells instead.

Moving only one cell or part of a record. A row of related information should stay together. Clicking a cell and cutting it does not select the entire worksheet row. Click the row number if all columns in that worksheet row belong together. In a table, select and reorder the table’s records rather than shifting unrelated worksheet cells.

Choosing the wrong destination row. Insert Cut Cells places the moved row before the row header you choose. Think in terms of which existing record should come immediately after the moved row. Inserting before the wrong row can make the move appear one position too high or low.

Reordering while a filter hides records. A filtered worksheet may show only some rows. Moving a visible worksheet row can affect data you cannot see or create a sequence that is hard to interpret. Clear the filter or use the table’s sort controls to reorder records consistently.

Forgetting linked information or formulas. Excel generally adjusts references when cells are cut and inserted, but formulas, charts, named ranges, and other workbook features can still merit a check. If the row feeds a report or another sheet, confirm those results after the move.

Tips

Use the row header for a whole-row move. Clicking the numbered label is the clearest way to include every column, even if some columns are off-screen. If the row is wider than the window, you do not need to scroll to select all its cells.
Move a block together. If several consecutive rows belong together, select all their row numbers and move the selection once. This preserves their internal order and is usually safer than moving each row separately.
Save a copy before major rearranging. Undo is useful, but it is not a substitute for a backup if you make many changes, close the file, or share it with others. Use File > Save As to create a working copy when the original must remain unchanged.
Take care with blank rows and totals. If a list has a total row, notes, or subtotals beneath it, do not assume the first blank row is a safe destination. Insert the moved row within the data area or use the table’s sort function, then verify that totals still cover the right records.
Use Undo promptly when needed. Ctrl+Z or Command+Z reverses the last action in many ordinary move cases. Some actions or later edits can change what Undo will reverse, so inspect the worksheet right away and avoid continuing to edit if you need to back out.

Troubleshooting

Insert Cut Cells is unavailable or grayed out: Check that you have cut the row, not merely copied it, and that you right-clicked a row header rather than a cell. Press Ctrl+X on Windows or Command+X on Mac, then right-click the destination row number again. A protected worksheet can block row changes; use Review > Unprotect Sheet if you are authorized and have any required password. If the workbook is read-only, save an editable copy first.

The row landed in the wrong place: Undo immediately with Ctrl+Z or Command+Z, then repeat the move. For Insert Cut Cells, identify the row that should follow the moved row and insert before that row. For Shift-drag, move the pointer until the insertion indicator is between the intended rows before releasing.

Cells were replaced rather than inserted: Undo at once. The Shift key may not have been held during the drag, or the selection may not have been moved by its border. Select the row header and use Cut, then right-click the destination row header and choose Insert Cut Cells. This method is easier to verify because it explicitly inserts the cut row.

Only some records moved, or the list looks out of order: Check for active filters, hidden rows, grouped rows, or a table. Clear filters and inspect the full list. For a table, use a unique temporary Order column and sort the complete table. Also check that you did not select just a cell range when you meant to select the worksheet row.

The row will not move at all: The sheet may be protected, the workbook may be read-only, or a merged-cell layout may interfere with inserting cells. Confirm you can edit the sheet, and review merged cells around the destination. If a merge prevents insertion, unmerge only if appropriate, move the row, and restore the layout carefully. Keep a backup before changing complex formatting.

Frequently Asked Questions

What is the safest way to move a row in Excel?
For a regular worksheet, select the row number, cut it, and use Insert Cut Cells on the destination row header. It inserts the row instead of replacing destination data. Save a copy first for important workbooks.

How do I move a row up one position?
Select its row number, cut the row, then right-click the row number immediately above it and choose Insert Cut Cells. Check the result before saving.

How do I move a row down one position?
Cut the row and insert it before the row that should follow it in the new order. For a one-position move down, that is typically the row two positions below the original row. Verify the surrounding records because the source row is also being relocated.

Can I move several rows at once?
Yes. Select a continuous block by dragging across the row headers or Shift-clicking the last row header. Cut the block and insert it before the destination row. Non-adjacent rows are better moved separately or reordered using a helper sort column.

Can I move a row with a keyboard shortcut?
You can select a worksheet row by clicking in it and pressing Shift+Space, then cut it with Ctrl+X on Windows or Command+X on Mac. Use the mouse to choose the destination row header and Insert Cut Cells. Shortcuts can vary with keyboard layout and Excel settings, so the row-header method is a reliable alternative.

Does moving a row change formulas?
Excel often adjusts cell references as cells are moved or inserted, but you should not assume every dependent result is correct. Check formulas, totals, charts, and linked reports after moving a row, especially in a workbook with complex references.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.