How to move a row down in Excel
To move a row down in Excel, right-click on the row number on the left side of the spreadsheet, select Cut, then right-click on the row below where you want it to go and select Insert Cut Cells. This shifts the row down one position and moves everything else up to fill the gap. The entire row moves together — all the data in every column stays in the same order.
If you only want to move the data in certain cells rather than an entire row, you can select just those cells, cut them, and paste them in a new location. But if your goal is to reorder rows in your spreadsheet, the cut-and-insert method is the fastest and safest way because it keeps your data aligned and doesn't accidentally overwrite anything.
Key Takeaways
- Right-click the row number (not the data itself) on the left edge to select the entire row at once.
- Use Cut and Insert Cut Cells rather than copy-paste, because insert-cut moves the row and shifts everything else automatically.
- The row you cut will move down, and the row that was below it will shift up to take its place.
- If you cut and paste without using Insert Cut Cells, you will overwrite the data in the destination row instead of moving it.
Selecting the entire row you want to move
Click on the row number itself — the gray box on the far left that shows "1", "2", "3", and so on. When you click the row number, the entire row highlights in blue. This selects every cell in that row from column A all the way to the last column, no matter how many columns your spreadsheet uses.
Do not click on a cell within the row. If you click on a single cell, only that cell is selected, and the move will only affect that one cell. You need the whole row highlighted before you proceed. If you accidentally selected a single cell, just click the row number again and the whole row will select instead.
Cutting the row and inserting it in the new location
Once the row is highlighted, right-click anywhere on the highlighted row. A menu will appear with several options. Look for Cut and click it. The row will now have a dotted border around it (sometimes called a "marching ants" border), which means Excel has marked it for cutting.
Now click on the row number of the row that is currently in the position where you want your cut row to end up. For example, if you are moving row 5 down to row 8, click on row number 8. Then right-click on that row number and select Insert Cut Cells. Excel will insert your cut row at that position, and everything below it will shift down one row automatically.
Why insert-cut is different from copy-paste
If you use Copy and then Paste, you will overwrite whatever data is already in the destination row. The row you copied stays in its original place, and a duplicate appears where you pasted. This is useful if you want to duplicate a row, but it is not what you want if you are trying to move a row to a new position.
Insert Cut Cells is different because it removes the row from its original location and shifts all the other rows to make room for it in the new location. Nothing gets overwritten. This is the correct method for reordering rows in your spreadsheet.
Moving a row back up if you change your mind
If you move a row down and then realize you want it back where it was, use the keyboard shortcut Ctrl+Z (or Cmd+Z on a Mac) to undo the move. This will reverse the last action and put the row back in its original position. You can undo multiple times if you made several moves in a row.
If you have already closed the spreadsheet and reopened it, undo will not work because Excel only keeps the undo history for the current session. In that case, you will need to manually move the row back using the same cut-and-insert method.
Moving multiple rows at once
To move more than one row at the same time, click on the first row number, then hold Shift and click on the last row number of the group you want to move. All the rows in between will highlight in blue. Then right-click and select Cut, click on the destination row, right-click, and select Insert Cut Cells. All the selected rows will move together and stay in the same order relative to each other.
If the rows you want to move are not next to each other, hold Ctrl (or Cmd on a Mac) and click on each individual row number. This lets you select non-consecutive rows. However, when you insert them, they will be placed consecutively in the new location, so this method works best when you want to gather scattered rows into one place.
Common mistakes and how to avoid them
The most common mistake is clicking on a cell instead of the row number. If you do this, only that one cell will move, leaving the rest of the row behind and creating misaligned data. Always click the gray row number on the left edge, not the cell itself.
Another mistake is using Paste instead of Insert Cut Cells. If you cut a row and then paste it, the data will overwrite whatever was in the destination row instead of shifting rows down. Always right-click and choose Insert Cut Cells from the menu after you cut.
A third mistake is forgetting to cut before you move. If you select a row and then click on a different row without cutting first, your selection will change and you will lose track of which row you wanted to move. Always cut when ready after selecting.
Frequently Asked Questions
Can I move a row to the very top or very bottom of the spreadsheet?
Yes. To move a row to the top, click on row 1, right-click, and select Insert Cut Cells. The row you cut will become the new row 1, and everything else shifts down. To move a row to the bottom, click on an empty row below all your data and insert the cut row there.
What happens to formulas when I move a row?
Formulas move with the row, but the cell references inside the formulas may change. If a formula refers to a specific cell like B5, and you move the row containing that formula, the formula will adjust to reference the correct cell in its new location. Check your formulas after moving to make sure they still calculate correctly.
Can I move a row in Google Sheets the same way?
Google Sheets works slightly differently. Right-click the row number, select Insert 1 above or Insert 1 below to create a new empty row, then cut and paste your data into it. Alternatively, you can select the row, cut it, click where you want it, and paste — Google Sheets will not overwrite data the way Excel does with a regular paste.
What if I accidentally moved the wrong row?
Press Ctrl+Z (or Cmd+Z on a Mac) when ready to undo the move. This will put the row back where it was. You can undo multiple times if you made several moves. If you have already saved and closed the file, you will need to manually move the row back.