Swapping Cells on Excel (Mac)

Swapping Cells on Excel (Mac)


Please is there a keyboard short-cut or some way of swapping cells content on Excel for Mac.
Lets say i have:
10 figures in Column A,
7 figures in Column B;

Now i want to move;

  • the 7 figures in B to A; &
  • 10 figures in A to B.

how do i go about it.



Got it guys… if you want to swap values in say Cell A1 with Cell B1 - highlight the cell A1 and hold “CMD + Shift”, and try move the cursor to the edge of the cell , and hand icon with come up. Drag the cell (while still holding “CMD + Shift”) a horizontal green shape will come up, drag this to Cell B1. Boom, cells swapped