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

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.

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
"eburris" wrote in message
...
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.