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
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
💡 Pro Tip: Quickly rearrange data without cutting and pasting.