In Excel: select the cells, put the pointer on the edge of the selection until it becomes a move cursor, then drag — hold Shift while dragging to insert them between existing cells instead of overwriting.
Select the cells you want to move.
Hover over the border of the selection until the pointer becomes a four-headed move cursor.
Drag to overwrite the destination, or hold Shift while dragging to insert and push the neighbours aside.
Keyboard route: Ctrl+X, select the destination, then right-click ▸ Insert Cut Cells (or Ctrl+V to overwrite).
To open a gap without bringing anything in: Home ▸ Insert ▸ Insert Cells ▸ Shift cells down or right.
To close one: select, then Home ▸ Delete ▸ Delete Cells ▸ Shift cells up or left.
What this does
There are three distinct ways to move cells and they differ in what happens to everything around them. Plain drag (or Ctrl+X then Ctrl+V) OVERWRITES the destination, with no warning beyond a confirm dialog if the target is not empty. Shift+drag INSERTS: the cells slide in and the surrounding cells shift to make room, which is the version people mean when they ask how to move a cell without destroying what is already there. Ctrl+X then right-click ▸ Insert Cut Cells does the same thing without the mouse gymnastics. Shifting cells DOWN or UP without moving anything in — Home ▸ Insert ▸ Insert Cells ▸ Shift cells down, and Delete ▸ Shift cells up — is a fourth operation, and it is the dangerous one: it moves only the selected columns' cells, so a row that was aligned across the sheet stops being aligned. Formulas referring to moved cells follow them; the reference is to the cell, not to its address. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “excel scroll instead of move cell”, 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 layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A2:A10 holds names that belong after the dates in column B. Select A2:A10, hover the edge until the cursor becomes crossed arrows, hold Shift and drag to the right of column B: the names insert as a new column and the old column C onwards shift right. Without Shift, the same drag would have overwritten whatever was in B2:B10. Shift-drag is the difference between rearranging a sheet and quietly destroying part of it, and it is not discoverable from the interface at all. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Here is the takeaway for “excel scroll instead of move cell”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
Common mistakes
- Dragging without Shift onto occupied cells and overwriting them — the confirm dialog is easy to click through.
- Shifting cells down in one column only, which breaks the row alignment for every other column in the table.
- Using Ctrl+C then Ctrl+V and leaving the originals in place; Ctrl+X is what moves.
- Trying to move part of a merged region or a filtered range, which Excel refuses with "That command cannot be used on multiple selections".
- Expecting formulas to break — references follow moved cells, which is usually what you want but occasionally is not.
Frequently asked questions
How do I move cells in Excel?
Select them, hover on the selection border until the move cursor appears, and drag. Ctrl+X then Ctrl+V does the same from the keyboard.
How do I move cells without overwriting?
Hold Shift while dragging, or use Ctrl+X then right-click the destination ▸ Insert Cut Cells. Both insert and push the neighbours aside.
How do I shift cells down?
Select the cells, then Home ▸ Insert ▸ Insert Cells ▸ Shift cells down. It affects only the selected columns, so check the rest of the row still lines up.
Do formulas break when I move cells?
No — a reference follows the cell it points at, so formulas keep working after a move. Text-built references such as INDIRECT are the exception.
Other ways people ask this
People reach this page typing “excel scrolling instead of moving cells” and “excel scrolls instead of moving cells”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “excel scrolling instead of moving cells”, “excel scrolls instead of moving cells” all point at the one operation explained on this page, which is why they all lead here.