How to exchange Rows And Columns In Excel

00:00so in this video I'll be showing you how to very easily swap cells in both

00:03vertical columns and horizontal rows here we have listed names in details

00:08including surname in column B first name in column C email address in D & Country

00:14in E Say for example you want to swap first name from column C to B and

00:19surname from column B to see you would need through the following first left

00:24click on the mouse in the first set of column c hold and drag to highlight all

00:28the data

00:30hover over the box line until the full black arrows appear then hold down shift

00:34on the keypad click and hold down the left mouse key and then drag the mouse

00:39to the left until you can see the big vertical line appear

00:43then you need to simply release the left mouse key and you see the two columns

00:47immediately switch

00:49equally if you're distraught the horizontal rows simply highlight the

00:52cells you wish to swap hover over the box liner to you see the four black

00:57arrows hold down shift click and hold down the left mouse button and drop it

01:03down under the road that you wish to swap it with let go of the mouse and

01:07there you go hope you find it useful please do like comment and subscribe and

01:11feel free to drop me an email with any requests