How to Swap Data in Excel

[williama.clarke]

while this is good to know, this isn't actually a "swap" its a shift which is why it doesn't work when you are not working with data that is adjacent. it takes the data you selected and inserts it from the edge of the destination cell that was selected and shifts everything else over from that point. When I was searching for swapping data in excel, I was more hoping to find something that allows me to select 2 different cells and lets me click something and it actually swaps them, no shifting of any other data. Again thank you for showing this Shifting/Inserting feature, it will also be useful to know for future things!

[shandell]

I'm not feeling well today, this gentleman knew I needed something to make my day.

I can't say it enough, I love his content.

[orlahastings]

That is super helpful, thank you so much. I use excel all the time and often want to swap cell contents like this but never knew this trick. Thank you for sharing. Your videos are always really useful and really well explained. And I like the short “bite size” ones especially as my brain can’t take in too much at the end of the day when I typically tune in to YouTube!

[shoaibtahir]

I was imagining something else, (cells shift from coding)
but this is also something I didn't know. Thanks

[eldarabdullayev]

Nice and clear. Very useful trick.
Thanks a lot

[saintsinnertv]

Helpful videos! Is there a way to transfer data from columns to another columns with data as well without losing any data from both sides?

[paulvanobberghen]

It is important to note that this does not work if your datas are formatted in an Excel table. No matter what direction you want to move, Excel will indicate the insertion line (horizontal only, the vertical line will not even display) but will not make the switch and will give you a warning it can't do so in a Excel table. There is a logic to this: an Excel table is a database where every row is a record and every cell a field of that record, and everything is supposed to be in the correct place in the first place.

[TheSeqfu]

When I attempt to do this the target cell never highlights, any ideas?

[ExcelStore]

Спасибо за интересный пример. Неспеша, все по делу и понятно.

[klatte]

This doesn’t seem to work in table mode or if filters are on — is that right?

[danieln]

Is there a way to swap multiple data in filtered mode?

[larslarsen]

How do you do the swap only using a keyboard?