In Excel: select the whole row, cut it with Ctrl+X, right-click the destination row and choose Insert Cut Cells so Excel moves the row without overwriting existing data.
On this page7
Click the row number to select the entire row.
Press Ctrl+X or choose Cut.
Right-click the row where the moved row should appear above.
Choose Insert Cut Cells, then verify formulas and sorting still make sense.
What this does
Moving a row changes its position while preserving formulas, formats and row contents. The safe command is Cut followed by Insert Cut Cells; it opens space at the destination instead of pasting over another row. Dragging can work too, but holding Shift is what tells Excel to insert rather than overwrite. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “move lines in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A task in row 18 belongs above row 7. Click row header 18, press Ctrl+X, right-click row header 7 and choose Insert Cut Cells. The old row 18 moves above row 7, and rows 7 through 17 shift down cleanly. Moving rows safely prevents the classic spreadsheet accident: a record is shifted in one column but not the others, corrupting the table. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “move lines in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
Common mistakes
- Pasting over the destination row and overwriting data.
- Selecting only some cells in the row, which can misalign records.
- Dragging without Shift and replacing cells instead of inserting.
- Moving rows inside filtered data without checking which records are hidden.
Frequently asked questions
How do I move a row without replacing another row?
Use Cut, then right-click the destination row and choose Insert Cut Cells.
Can I move multiple rows?
Yes. Select all row headers first, then cut and insert them together.
Will formulas update?
Most references adjust, but audit formulas that depend on row order.
Other ways people ask this
This is also commonly searched as “excel move line” and “how to move a line in excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “excel move line”, “how to move a line in excel” all point at the one operation explained on this page, which is why they all lead here.