Excel TutorialLesson 8Free preview
Excel Move Cells
This lesson is part of Excel · All levels
Summary
This lesson discusses moving the contents of the cell: using cut and paste, or dragging the selection edge directly to the target. When the cell containing the formula is moved, the reference automatically adjusts to the new position so that the result remains consistent. But paste to the area that already contains the data will overwhelm the old data, so always check before you paste.
Key points
- Move by Ctrl+X then Ctrl+V, or drag the selection edge with the mouse
- The reference formula adapts to follow the new position when the cell is moved
- Paste to the destination containing the data will overlap the old content
- Use Insert Paste when you want to insert cells without hitting the target
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.