Excel: how to swap rows

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

Leave a Reply

Your email address will not be published.