How to Swap Columns / Rows in Excel | Joe The Excel Geek

Learn how to very easily swap data in different vertical columns or horizontal rows.
If there are any topics that you would like a video on, please e-mail me at: [e-mail]

[@lauriepower1676]

You have just saved me about a thousand minutes of DUMMMM manual swapping!

[@yelenamaltseva1729]

Same here!!! I was going mad......

[@thejamiefoster]

You saved me SO much time with this video. THANK YOU!!

[@jonathanmatloa8841]

We love you. Straight to the point

[@shum21]

Thank you! Just what I needed.

[@djames4859]

Thank you for saving me a whole lotta time!

[@chinmaydas7320]

Thanks as simple as I wanted it to be

[@tulsatrash]

Thank you. Was helpful.

[@saaneroa5024]

Very helpful thank you.

[@dussanbonilla]

Excellent and simple video. Would be great to know a method for non adjacent rows/columns

[@kadupukotlasatishkumar5993]

very simple explanation very good

[@lakshyadalal8296]

Thanks bro it really helped

[@Hosamo7]

amazing, thank you

[@scottb7655]

This doesn't technically swap, it moves. It only swaps if they are right next to each other. If I bring it down 4 rows, it moves the other over, not "swap"

[@manusreenivasan5310]

Got any solution ??

[@MohsinFarooqRana]

Thanks Joe

[@ghssammandivilaiammandivil1890]

SUPER VERY THANKS

[@ioan-cristiansimionov7533]

Thank you !

[@RUDYHARIANTO]

Thank You !

[@harikumar-cq1je]

Thanks Man !

[@vidyareddy3805]

Thank you :)

[@bendegorro754]

Just add info, if your table had hyperlink (sort & filter function), make sure remove it first, by blocking all boxes with active hyperlink, then select 'clear -> clear hyperlinks' (the icon next to Sort & Filter).

[@AliAsghargohar]

thanks joe

[@mariamrauf219]

THANKS!!

[@PhotoliaStudios]

Thanks man..

[@JibHyourinmaru]

tqvm!

[@jazviolet07]

THANK YOU

[@fisherman7633]

What if you wish to swap rows #1 and #3?

[@donovanyang6942]

Thanks

[@Danushka1985417]

Thanks ...👍

[@Ouzyman]

Nice

[@LiamDePaux]

the fact that it is not a click-and-drag is so infuriating. Thanks excel for making me google every little thing I want to do instead of making it intuitive

[@mohammadabdulazim7291]

It doesn't work on my Excel. when I moved, it says to replace the destination row/column.

[@Petertronic]

Cool beans.

[@muhammadsyahrulafif3697]

Love u

[@ladams5356]

How do you swap columns not adjacent to each other?

[@VBAbyMBA]

Above-mentioned method have flaws it only work with adjacent cells. You can Create a macro to swap cell values as shown in video. kzbin.info/www/bejne/b3XJgp1omLd-jdE

[@jbkmjl]

There's data already here. Do you want to replace it? Is the message I get

[@pratikjain9046]

But that doesn't happen if we create a table in it

[@Ppatrickk44]

Video starts at :24

[@manaskumarsahu4632]

Not happening

[@Being_Unidirectional]

It functions as move not swap🌶️

[@carloscazar1406]

Thank you!

[@ajaybasani2952]

Thanks

[@HamidAli-sg8ip]

Thanks