How to Swap Data in Excel

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

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!

williama.clarke
Автор

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.

shandell
Автор

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!

orlahastings
Автор

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

shoaibtahir
Автор

Nice and clear. Very useful trick.
Thanks a lot

eldarabdullayev
Автор

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?

saintsinnertv
Автор

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.

paulvanobberghen
Автор

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

TheSeqfu
Автор

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

ExcelStore
Автор

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

klatte
Автор

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

danieln
Автор

How do you do the swap only using a keyboard?

larslarsen
join shbcf.ru