Hi, this is Wayne again with a topic “How to Swap Data in Excel”.
Foreign Excel video, I’m going to show you how to easily and quickly swap the values of two different cells. Let’S take a look here. I have a list of contacts and, if you look closely you’ll see that some of my data in columns d and e is incorrect. Salem should be here in the city column, and this address should be in the business address column. We have similar problems down here below, so of course, I could copy paste the data or I could create a column between d and e and temporarily move some of the data into that middle column and then rearrange the data where it needs to go.
And then I could delete that extra column, but those options seem complicated and a little Annoying there’s got to be a better way and there is all I would need to do to swap this data is choose one or the other cells. It doesn’t matter which hold the shift key on the keyboard and then put your mouse at the very edge of the cell. It doesn’t matter really which Edge somewhere on one of these four lines that creates the blocks around the cell. I’M going to put the mouse here and you can see that the mouse pointer turns in to a four-sided arrow and from there I’m going to click and hold the click and then drag to where I want to swap this data.
Now, if you look closely there’s some insertion points that are appearing – and this is the one I want to select – this will move Salem to where 494 Columbia Avenue is, and vice versa, so I’ll release the mouse button and my spreadsheet scrolled to the right. So that might have been a little confusing, but take a look at the results. Now Salem is where it needs to be, and the address is where it needs to be with this next example: let’s try the other direction, so I select the cell hold shift this time, I’m going to use the top line of this cell with the shift key Held I’m going to click and drag and drop the cell here you can see the insertion point there to the left and I’ll release the mouse button and the data is swapped. Now for this next example, I want to point out that there are other destination options for this data.
If I don’t go all the way to the left, but rather part way, you can see the insertion point is above and if I go a little bit lower, the insertion point is below let’s try that one I’ll release the mouse button and now the selected data That I had here moved to here now: that’s not at all what I wanted, so I’m going to hold Ctrl and tab Z to put it back where it was, but I wanted you to see that it is possible to move it to the wrong place if You’Re not careful and notice that it didn’t actually do the swap, so I’m going to undo that control Z. So let’s try swapping the contents of this cell with the contents of this cell. I’Ll click here hold the shift, key click and drag all the way to here.
My insertion point shows up there to the left. I release the mouse button and it worked but notice what happened. The address moved here – yes, but the company name shifted to the right and LaGrange moved to the right, so everything shifted to the right in this case.
So in this article I’ve shown you how to quickly and easily swap data from one cell to the next. It works best when the two cells are right next to each other, but even if they’re, not it’s possible, but it becomes more of a cell shift than a swap thanks for watching. I hope you found this tutorial to be helpful.
If you did please like follow And subscribe, and when you do click the bell and you’ll be notified when I post another video, if you’d like to support my channel, consider clicking the thanks button below the video or you could support me through my patreon account or By buying Channel merch and you’ll see information about those options in the description below the video speaking of patreon, I want to give a quick shout out to my five dollar patreon supporters. Thank you. So much for all you do to support the channel.
.