ShortcutdrillExcel shortcuts / editing / Cut and move a cell
Cut and move a cell in Excel: Ctrl+X, move, Ctrl+V (Mac: Cmd+X, move, Cmd+V)
| Windows | Ctrl+X, move, Ctrl+V |
|---|---|
| Mac | Cmd+X, move, Cmd+V |
| Group | editing |
Drill: Move a note. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+X marks the selection to move, the arrows take you to the destination, Ctrl+V moves it. Unlike copy, cut keeps the references in moved formulas pointing at the same cells.
The common mistake
Cutting and pasting over a cell that other formulas depend on: those formulas now point at the moved location. Use copy and paste values if you only need the number.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
Why does cut and paste change my other formulas?
Formulas that referred to the cut cell follow it to the new place. That is by design; copy instead if you do not want them to follow.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill