How to quickly swap contents of two cells in Excel?
- Manually swap two adjoining cell contents. ...
- Select the cell you want to swap. ...
- Press Shift key, and put the cursor at the right border.
- Then drag the cursor to the right border of cell B4.
- When there displays “工”, release the mouse.
- And the two cell contents have been swapped.