Is there a quick shortcut to swap the data in two cells?

E

eburris

I'm working with large address spreadsheets that have some of the address
data reversed. I cut one cell and paste to an empty cell then cut and paste
the other cell in the cell that I just cut from. Then I cut the first one I
moved and paste it where the second one was. Is there a shortcut to just swap
the two?
Thanks.
Earl B.
 
F

Frans van Zelm

Hi Earl,

- Select either of the two cells
- Point at the black border
- <Shift>-drag this cell to the other side of the neighbouring cell
(You'll see a T-bar moving over tour sheet)

Frans
 
Top