Move and Shift Cells
Three quite different problems arrive under this heading and only one of them involves moving any data. Arrow keys that scroll the window rather than stepping between cells are a keyboard state, not anything in the workbook. Relocating a block of values is the ordinary case, and the single decision there is whether the destination is overwritten or pushed aside. Shifting cells up or down is the third, and the one to watch: it moves the selected columns and leaves every other column where it was, so a row that lined up across the sheet quietly stops lining up.
The formula
the window scrolls, the cursor does not move a keyboard state — see the scroll-lock hub
relocate a block onto empty cells drag the selection border
relocate it without losing the destination hold Shift while dragging, so it slots in
open a gap in some columns only Insert > Shift cells down or right
close a gap in some columns only Delete > Shift cells up or left
open or close a gap across the whole sheet insert or delete the entire row instead
repeat the cell above rather than move it Ctrl+D down, Ctrl+R acrossA worked example
Somebody deleted one cell in column C instead of the whole row, so from row 60 down, column C sits one row higher than everything beside it.
Select C60, right-click, choose Insert, and pick "Shift cells down".
Column C alone slides down a row and lines up with its neighbours again — the repair works precisely because the command touches one column. Run the same thing over C60:F60 and four columns move while A and B stay put, turning one misaligned column into four. That asymmetry is the whole reason Insert > Entire Row is the safer instinct whenever more than one column is in the selection.
Which one do I need?
| If you want to… | Use |
|---|---|
| The window scrolls but the highlighted cell never moves | That is a keyboard state rather than an Excel one, and the sheet is untouched |
| The cursor will not move and the window will not scroll either | The sheet is protected with "Select locked cells" unticked, or a macro has fixed the scroll area |
| A block needs relocating and the destination is empty | Drag the selection border — with nothing in the way there is no decision to make |
| The destination is occupied and must survive | Hold Shift throughout the drag so the block slots in rather than landing on top |
| A gap is needed in some columns but not others | Insert > Shift cells down, understanding that it deliberately takes those columns out of step |
| A gap needs closing in some columns but not others | Delete > Shift cells up, with the same caveat about the columns either side |
| The whole sheet should stay aligned | Insert or delete an entire row or column instead — the alignment is what those commands protect |
| Dragging does nothing at all | File > Options > Advanced has "Enable fill handle and cell drag-and-drop" unticked |
| A value needs repeating down a column rather than relocating | Ctrl+D copies the top cell of the selection into every cell below it |
| It is whole columns or rows that should move | Shift+drag works on headings and row numbers too, and cannot break the alignment |
| You meant the lines drawn between the cells | Those are gridlines or borders, and they are switched off separately |
Frequently asked questions
When is Insert > Shift cells down the wrong choice?
Whenever more than one column is selected and the rows are meant to stay in step. The command moves only what you selected, so pushing C60:F60 down leaves columns A and B behind and every row from 60 onward now mixes two records. It is the right tool for repairing a single column that has slipped, and the wrong one for making room in a table — Insert > Entire Row does that without disturbing anything.
Why can I not drag cells any more?
The setting that permits it has been turned off: File > Options > Advanced, and tick "Enable fill handle and cell drag-and-drop" under Editing options. The other candidate is a protected sheet, which blocks dragging, the fill handle and most editing together, and Review > Unprotect Sheet restores all of them at once. Cut and paste continues to work in both situations.
What is the difference between Ctrl+D and copy and paste?
Ctrl+D fills the top cell of the selection into every cell below it in one keystroke, across as many columns as the selection is wide, so selecting B2:D50 and pressing it copies row 2 down the whole block. Copy and paste needs the source chosen separately and leaves the clipboard marching-ants border behind. Both adjust relative references the same way, and both overwrite whatever was there.
Can I move cells while a filter is on?
Not as a block. A filtered range is a multi-area selection as far as Excel is concerned, so cutting or dragging it fails with "That command cannot be used on multiple selections" — and Alt+; makes that worse rather than better, since it deliberately produces a multi-area selection. Clear the filter, move the cells, and reapply it, or copy the visible rows to a new sheet and work there.
New guides and tools, once a month
DE + EN · double opt-in · no spam