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.
Thanks
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