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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Cut & Paste in Excel without erasing cell borders? 1
pasting with filter results into sequentual cells not same row? 1
Cut and Paste 2
Keeping forumla cell reference after cut and pasting 3
Moving a bunch of data 1
Shortcut keys for copying data down 29,000+ cells 2
Is there a way to switch data between two cells? 1

Back
Top