Excel How-To: Moving and Relocating Rows and Columns

How-to/tutorial video showing how to move or relocate rows or columns within your Excel worksheets.
Purchase Excel here as part of the Microsoft Office Suite: amzn.to/3xprJP1
This is a one-time one-device purchase (PC or Mac) Home & Business 2019.
Home & Student version: amzn.to/3yuKIbd
Buy it once and you own it.
Or, get the 12-month subscription via Microsoft 365: amzn.to/3hn9Fj7
These are Amazon Associate/Affiliate links.

[@abdulkaderali5657]

Hello Andy. I would like to say thank you very much. I was just writing some data in Excel, and I needed to move and relocate some text to rows and columns, and I didn't know how to do it. I checked RUclips to get some help. I watched many videos, but it didn't help. I came across your video and I said hum just check this last video it might help. And yes that's what I have been looking for. It helped me complete my task. Your video was 10yesrs old but it helped me 2024 and it help even after 100 y Thanks again Andy keep up the great work. God bless you.

[@AndyMahnFL411]

So nice to receive your very thoughtful comment, I'm glad that this video helped you. And it is true that Excel from early versions to today, has withstood the test of time in that many of the features and functions introduced early on have carried forward.

[@Blz-qr4wd]

7 years have passed and your video still helps people what a legend

[@AndyMahnFL411]

It's funny, but that absolutely amazes me as well. Grateful to have withstood the test of time.

[@MoneshKundkar27]

Now 10 years passed and this video still helps 😅 thanx @andymahnfl411

[@jb7974]

Andy, you are the best. I have never used excel before and your videos are by far the easiest to follow. If I can do it, there's hope for Anybody!
Thank you so much🤗🤗🤗🤗🤗🤗

[@AndyMahnFL411]

You can certainly do it! Very happy I was able to help you, thanks for your thoughtful comment.

[@goodnamesareallgone1]

Ten years later, the video/information is still good. Thank you.

[@vishvaweerasingha171]

I am a Full-Stack Python developer, and this is something I couldn't figure out myself ! Thank you !!

[@AndyMahnFL411]

You're welcome! I would certainly place a wager on the fact that you I know a lot more than I do!

[@VRose-ig4qj]

Awesome stuff man. You are saving us so much time and looking stupid asking questions. I LOVE RUclips!

[@AndyMahnFL411]

I love it as well, happy to help!

[@lifewithgouher9748]

Thank you it really helped me i wasted my 2 hours watching other trash videos. i am suprised this video helped me in 2024 after a decade.. thanks Andy :D

[@AndyMahnFL411]

🫶🏽, and you are very welcome ☺️

[@mustluvcandy9430]

Exactly what I needed! Problem solved. Thank you!

[@AndyMahnFL411]

👍🏼 🫶🏼

[@thehomeboyz]

Straight and to the point! perfect How-To video.

[@AndyMahnFL411]

👍🏼, thank you.

[@kennethochoa7550]

just what I needed thanks

[@AndyMahnFL411]

👍🏼 👌🏼

[@lovediam301]

Thank you I needed this today ❤️

[@AndyMahnFL411]

You're quite welcome 🫶🏽

[@brianrosado7211]

Just what I need. Thanks. Very useful.

[@almazabraha]

Thank you very helpful it just worked for me now.

[@AndyMahnFL411]

Excellent! These skills will prove helpful.

[@AXMXND]

Tenk yu sou mach yutub men, witaut you i have hed make my progect agen.

[@meditationtorelax8915]

Thank you!!! You saved my life my friend!!

[@AndyMahnFL411]

Probably more credit than I deserve, but happy to have helped you!

[@PradnyaWakle]

it's really helpful, thank you

[@AndyMahnFL411]

Glad it was helpful!

[@HforHelm]

The shift key trick is amazing thank you so much that helped a lot.

[@AndyMahnFL411]

Def one of my faves, happy to share.

[@maudeelam9507]

Excellent I have been looking for this information and yours was the best.

[@AndyMahnFL411]

So glad this was helpful for you, thanks for the comment.

[@karishmapriyadarshini2400]

Thank you.. I hv been struggling with this too... U hv given very clear, detailed description..

[@AndyMahnFL411]

I'm glad my content was easily understandable for you, thanks for commenting!

[@shibojitd]

You saved me a ton of work🙏🙏🙏

[@purangurung2153]

Thank you sir it helped me.

[@dolayesoul]

Omg thank you so much , needed this for my google course

[@greenmango715]

Very helpful,Thank you.

[@AndyMahnFL411]

👍🏼

[@soumicksarkar130]

10 year still rocking

[@claireb.5232]

I work on excel all day in my new job and couldn’t remember how to drag the rows. It was driving me CRAZY! THANK YOU!!!

[@AndyMahnFL411]

You're welcome!

[@native_savage5561]

Great and useful even to this day, thanks a lot!

[@AndyMahnFL411]

You're welcome and thank you for your comment. Although the version featured is quite outdated, a lot of the functionality remains the same in today's Excel version

[@hungryaco]

40 seconds in and I got it. Thank you!

[@AndyMahnFL411]

Great, nothing beats a quick result!

[@moontiger6549]

Thanks. Very insightful

[@ramlilagurung2059]

Thank you sir. Your video helped me

[@CSEngineerInsider]

As a Data Entry operator I suggest people's watch your video's.

[@AndyMahnFL411]

Thanks for your endorsement!

[@Ndaks_Media]

Thank you for this, it is so helpful.

[@AndyMahnFL411]

You're welcome!

[@shahidvids]

Wish I knew this excel feature long back...Thank you Andy, You saved me from RSI..

[@AndyMahnFL411]

Mohammed Shahid Hussain, glad to hear that this was helpful for you. RSI? Repetitive Stress Injury? Ouch.

[@DowsStockTalk]

Thanks man you help me in less than a minute

[@AndyMahnFL411]

Can't beat feedback like that, thank you!

[@FILIPINOAMERICANHEARTCHANNEL]

thank you very much i need this in my job

[@AndyMahnFL411]

All the best

[@luckydehury56]

Thank...it was help me alot

[@yuritatianarodriguez5580]

Thank you!

[@Jonas-so7wd]

*Thanks for this tutorial! Thanks!*

[@AndyMahnFL411]

The Zamurai, and you're welcome, I hope this tutorial helped you, thank you for commenting.

[@ibrahimgamalf]

Thank you

[@marthasilvafeinman5499]

Thank you, your video was the one that help me doing it with a laptop. I guess that a mouse will be of better help. Once again, thank you.

[@AndyMahnFL411]

My pleasure, and yes, absolutely, using a mouse will give you the finer level of control that you might work best with in Excel.

[@sehershahin6021]

Very helpful! Thank you!

[@QUIETSTORMXXX]

Omg!!! Thank u! This was so helpful! There's hope yet. :)

[@AndyMahnFL411]

🤣 👍🏼

[@yusufmardhani7749]

Thank you very much

[@ChimDaddy]

Absolute legend! Thank you!

[@AndyMahnFL411]

☺️

[@lisareid108]

Thank You.

[@tinkageorgewilliam871]

Thank you. You are the messiah!!!

[@AndyMahnFL411]

Thanks, I don't think I'm worthy of that high, high praise! But, I will certainly accept it!

[@tinkageorgewilliam871]

Hahah... Honestly your video helped me a lot. Thanks.

[@AndyMahnFL411]

@@tinkageorgewilliam871 😊👍 I am glad to know that, thank you for taking the time to comment!

[@tinkageorgewilliam871]

@@AndyMahnFL411 Welcome.

[@nanaamasafo1289]

Thank you very much 😊

[@AndyMahnFL411]

You're welcome 😊

[@rjrockefeller8824]

man thanks! you're a genius

[@AndyMahnFL411]

Thank you, but I have to humbly admit that nowhere near the level of the folks who make these amazing programs.

[@johngomez2323]

Cheers bro! Thank you

[@AndyMahnFL411]

👍🏼

[@alkareementerprises7361]

thank u its very simple but informative

[@AndyMahnFL411]

Excellent, thank you so much for your comment!

[@jalalghalib8632]

Thank you very much sir
you saved me a lot of time.

[@AndyMahnFL411]

Awesome, happy to hear this worked for you! Then again, I guess we all have plenty of time on our hands now.

[@eri711128]

Genius !!!!!

[@jorgereis9813]

Thanks a lot!

[@AndyMahnFL411]

Welcome!

[@qaweemahmad3328]

Thanks

[@popp]

thanks so much!

[@n-allrounder9567]

Very impressive. 1st time saw your video. oustanding

[@AndyMahnFL411]

Thanks for your thoughtful comment 👍🏼

[@n-allrounder9567]

@@AndyMahnFL411 why don't you upload Excel videos now?

[@AndyMahnFL411]

@@n-allrounder9567 great question, basically just very busy. If there are topics of interest, I can certainly do so.

[@n-allrounder9567]

@@AndyMahnFL411 please bring more Excel easy tacts like this one please

[@AndyMahnFL411]

@@n-allrounder9567 Thanks for the interest, I'll try to develop more Excel content soon!

[@adamfrew6699]

Thanks for sharing, great tutorial!!!!!

[@AndyMahnFL411]

Thank you very much, happy to have helped!

[@FlywithZahanat]

well and explained nicely

[@AndyMahnFL411]

Thank you 👍🏼

[@CHARITAJONES]

Great Video!!! ♥ Thank you so very much ♥

[@Nacho_doritos7777]

W video it helped me so much 🐧

[@AndyMahnFL411]

great!!

[@choudharywaseem1674]

Thanks Brother, you sought my big problem

[@AndyMahnFL411]

My pleasure, my happy to help you out here.

[@amayaerin]

Thank you so much 💖

[@marksalazar2806]

Great help 1:49

[@NicoleCorby]

Thank you!!

[@AndyMahnFL411]

You bet, hope it was useful.

[@damiandavila1747]

So useful
Thanks

[@NoliPugay]

so simple right?

[@ahmadbairat9553]

thanks brother

[@Sanj_bhatti]

awesome dear you are legend

[@AndyMahnFL411]

Ha! 🤣☺️, thank you

[@rkgp1304]

Thank you sir

[@m.grohman2463]

Thanks !!

[@chatsontap8373]

THANK YOU!

[@chewemulambia7242]

Thank you so much. This is of great help to the work I am currently doing!!!

[@AndyMahnFL411]

Happy to hear that this sounds like great timing! Good luck.

[@cicada-ft6eb]

thank you

[@lou.104]

Thank you SIR

[@AndyMahnFL411]

😊👍🏼❤️

[@sagarkaware8534]

Awesome trick 🔥 Thank you Sir

[@warcatbattalion]

you are a god

[@AndyMahnFL411]

Now that's very high praise - thank you; I am mere mortal : )

[@micky992]

Hi mate, thanks very much. That resolved my problem.

[@AndyMahnFL411]

Awesome, glad this helped you.

[@odinenoc7364]

Loveeeeeee you from Turkey =)

[@AndyMahnFL411]

Well, hello Turkey! Greetings to you!

[@user-kq6hu4vj3x]

thanks dude. thanks a lot ))

[@AndyMahnFL411]

Night Wolf, sounds like this was helpful to you, hopefully so!

[@coach.patrik1839]

thank u for this short, clear great video !

[@AndyMahnFL411]

you bet, glad this helped you!

[@TorQueMoD]

(1:17 for the instant answer) Thank you for this video, though you should have just jumped into the solution right away :P

[@AndyMahnFL411]

That's fine, I certainly appreciate the bookmark. Some folks like a little bit more background as they learn and some like to get to the point.

[@14mastermo]

Thank you so much

[@sunilkumar-iq2oq]

Perfect , you are excellent

[@AndyMahnFL411]

Second to you! Thank you for your comment.

[@asyanovikov4749]

THANKS!

[@KRB677]

hi, i need one function that disables excel from detecting the date format right before you open the file

[@francopascoe2317]

You are a Legen sir

[@AndyMahnFL411]

Second only to you! 😉, thank you.

[@thilanielvitigala8326]

Thanks a lot it worked...!!!!

[@AndyMahnFL411]

Super! Glad it helped you. I have others that may prove useful.

[@reliefdevelopment2643]

very helpful

[@808breaksbad.]

TY!!!!! easy to understand

[@AndyMahnFL411]

DeWALTer_White awesome, I hope it helped you.

[@NoliPugay]

Good One! keep it going...

[@AndyMahnFL411]

Thanks! There's plenty more where this one came from.

[@krishj8011]

thanks... very useful....

[@AndyMahnFL411]

Sure thing.

[@michaelstidham5957]

Thank You!

[@AndyMahnFL411]

Michael Stidham, sure thing!

[@garretreed9709]

Thank you. Not sure why it’s hidden behind a shift key. Sometimes excel things aren’t I tuitiva

[@AndyMahnFL411]

Not always intuitive, but save a ton of time once committed to memory.

[@adamjanowski84]

thx!!!

[@AndyMahnFL411]

@@adamjanowski84 👍🏼

[@ARUNKUMAR-ow3xl]

Good information

[@AndyMahnFL411]

Thank you!

[@sisigisele1541]

Thank uuuuuu so much
Isso ajudou Muitooo
Gracias

[@laurawest9353]

Thankyou!

[@AndyMahnFL411]

Laura West I hope this was helpful, thank you for stopping by.

[@MrMeghdadi]

informative, thank you

[@AndyMahnFL411]

You are certainly welcome.

[@anasmaghrabi9564]

What if we have formulas in this Row that depends on the upper or the last row will it still not destroy the code ? Or this only work with data not formulas ?

[@AndyMahnFL411]

Anything in the row moves with the row (formulas, text/data, formatting).
Formulas will adjust as per new positioning in the sheet following the move.

[@zay712]

Thank you!!!!

[@AndyMahnFL411]

You bet!

[@paulhetherington3854]

< /y(2t) = 8' 8=4+c''_cmd void cell = move handle-pointer map it as graph matrix in P-WVo''' 4=m(t)Mo'' 12'Rt''' create X cell / >

[@katherineh9814]

I'm having problems. I'm using a Mac and all this method does is copy the cell contents. Any suggestions? Thanks.

[@AndyMahnFL411]

After selecting the row or range of data that you'd like to move, you should be able to use the Control + X to cut and Control + V to move your data.

[@indrajitdutta7736]

Thanks a lot.....

[@AndyMahnFL411]

You are welcome.