Switch position of cells/rows/columns
Master this Excel shortcut with our comprehensive guide
Drag (Mouse) Shortcuts
Shift + Drag
Shift + Drag
How to Use This Shortcut
Keyboard Shortcut
Shift + Drag
Instructions
1. Select the cells, row, or column you want to move
2. Hold Shift
3. Drag to the desired location
4. Release to swap positions
2. Hold Shift
3. Drag to the desired location
4. Release to swap positions
Keyboard Shortcut
Shift + Drag
Instructions
1. Highlight the cells/rows/columns
2. Hold Shift
3. Drag to a new position
4. Release to switch their location
2. Hold Shift
3. Drag to a new position
4. Release to switch their location
💡 Pro Tip: Quickly rearrange data without cutting and pasting.
Quick Actions
More Drag (Mouse) Shortcuts
Ctrl + Drag
Ctrl + Drag