Excel for Beginners - Cut, Copy and Paste like a Pro!

Lesson 4 of 13 - Get started with Excel and learn how to cut, copy and paste like a pro user. Download the Excel file for all 13 lessons here: www.myonlinetraininghub.com/workbook-downloads
Get the full course here: www.myonlinetraininghub.com/microsoft-office-online-training-courses
View all my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: www.linkedin.com/in/myndatreacy/

[@kimberlyhuff9617]

This saved my job! Thank you Holy Spirit for leading me here!

[@MyOnlineTrainingHub]

Awesome to hear!

[@JessicaMillerNashville]

Finally I feel comfortable with this simple task because of this easy video! Thank you!!!

[@MyOnlineTrainingHub]

Great to hear! 🙏😊

[@tiadenise4519]

I have been using Excel for over 15 years and I still consider myself a beginner. I recently left my job and am using this “in the meantime” period for professional development courses. Stumbling across your channel was the best professional development gift that I can give me self-a perfect start to 2022! I just completed your intro course and can see how I’ve wasted a great deal of time. I am a research administrator/analyst and work with data. After watching these video, I can only imagine the amount of time I have wasted. I cannot wait to get to more advance courses on pivot tables, dashboards, etc., which I hope will help me to prepare detailed projections and comprehensive budgets. Obrigada!

[@MyOnlineTrainingHub]

Great to hear you found my videos helpful, Tia!

[@rezayoun6571]

I love your tutorials very very much. Thank you.

[@MyOnlineTrainingHub]

Happy to hear that!

[@Mphc18]

Yep, I'm so silly, it finally clicked today and I've completed the course! Thanks for replying.

[@wayneedmondson1065]

Hi Mynda. Thanks for the cut, copy and paste tips. Always useful to review the different ways to do those procedures. I like to remember the keyboard shortcut ALT+H+FO to open/close the clipboard pane which has a lot of functionality, as you demonstrated, but remains hidden unless you take the steps to expose it. Excellent review. Thumbs up!

[@MyOnlineTrainingHub]

Thanks for sharing the keyboard shortcut for the clipboard, Wayne! I'll try to remember that one.

[@nikakalichava8012]

Even thou i have 8 years of experience in Excel, I always look up to these beginner guides. You never know what you can learn new.

[@MyOnlineTrainingHub]

Great to hear, Nika! 😊

[@julianarichard1666]

Jjjjjkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk

[@abdulkareemal-mahdi4288]

You’re amaizing and i wach majority of your videos especially the dashboard thanks 🙏 alot

[@MyOnlineTrainingHub]

I appreciate that!

[@johnborg5419]

Thanks Mynda. That was Great!!! : ) : )

[@MyOnlineTrainingHub]

Glad you liked it!, John!

[@Kingagaink]

Awesome video finally i understand all the type's of paste ❤️❤️❤️❤️❤️

[@MyOnlineTrainingHub]

Great to hear 😊

[@rizalfatoni4075]

Just know new safer method for pasting copied data to avoid messing around in spreadsheet. Thank you Mynda!

[@MyOnlineTrainingHub]

You're so welcome, Rizal!

[@wowmovies10]

I learn's today how to use copy, paste and cut in new ways Thank ma'am 🙏🙏

[@MyOnlineTrainingHub]

Glad to hear that, Aashish!

[@moisestatis5418]

Great video! 👌🏻

[@MyOnlineTrainingHub]

Thank you 🙏

[@Mphc18]

Thank you for this series! To follow along with it, do you have the workbook you're using in this video , available to download so we can follow in real time and mess around with?

[@MyOnlineTrainingHub]

There’s a link to the workbook in the video description.

[@Mphc18]

@@MyOnlineTrainingHub thanks for getting back to me... looks like I found the link but it’s available for paying customers. Thanks anyway! www.myonlinetraininghub.com/preview-excel-syllabus

[@MyOnlineTrainingHub]

That's not the link in the video description. The workbook is available for free if you just follow the link in the video description as I suggested. Here it is again: www.myonlinetraininghub.com/workbook-downloads

[@seandenard3341]

Love your videos, they are very helpful! Learned a really great trick in this video that was going to make my life much simpler. Special paste - paste link. I have several cogs spreadsheets that I condense into a few. Manually copy and paste every time. Not hard but annoying when I know there's probably a dozen better ways. I'm still learning with help from your videos! This one has me stumped though. Wondered if you might help me. Successfully pasted link instead of just the regular paste. When I change the original it automatically changes the data everywhere else. Easy peasy. However the files are now too big to attach to an email. I've googles like crazy and can't find anything helpful. Any wisdom you can offer on this would be greatly appreciated? Thanks in advance!!

[@MyOnlineTrainingHub]

Glad you find my videos helpful, Sean! You could embed your spreadsheet in a web page instead of emailing it. I've got a video on that coming out next week, so keep your eye out.

[@sukshma239]

Hi Maam! Is there a way to copy multiple UUIDs from different cells in a sheet and paste them in a single cell of another sheet of the same workbook? Thank you for your wonderful videos! :)

[@MyOnlineTrainingHub]

No, you can't copy multiple cells and paste them into a single cell, but you can use the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function

[@rezayoun6571]

Hi thank you so much for great tutorial. Please teach me how to make a sales plan for electricity branch with bill printing with Excel. Thank you very much.

[@MyOnlineTrainingHub]

Glad you enjoyed it, Reza!

[@rezayoun6571]

@@MyOnlineTrainingHub so please teach me how to make a sales plan for electricity branch with bill printing with excel .thanks very much

[@chemay6027]

❤❤❤

[@MyOnlineTrainingHub]

Thanks for watching 😊

[@glamourhusnisha6809]

Thanks a lot

[@MyOnlineTrainingHub]

Most welcome :-)

[@joelmayele]

I’ve got a question I have a long list that I want to paste and for it to get into individual cells but it’s being paste in one cell I don’t know why if you could help me that would be great

[@MyOnlineTrainingHub]

Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@selectthedead]

Hi, I have a problem with copy pasting. Maybe you can help me: If I want to paste and not overwrite data you showed the popup with the shift cell up or down. How can I activate this feature? In my german Version it does not seem to work.

[@MyOnlineTrainingHub]

This feature isn't something you turn off or on. I wonder if you're not placing your mouse on the edge of the cell border. You need to get the 4 headed arrow mouse pointer before left-clicking and dragging while holding shift.

[@tonyscott5045]

Hi Mynda, I hope you can help me with a small problem. I'm using Office 2013 on a new laptop. Every time I hit Copy the whole worksheet sort of jumps for a fraction of a second and then everything is OK. Paste works OK, but it's disconcerting and hard on the eyes to have the sheet jump around like that. Any ideas?

[@MyOnlineTrainingHub]

Hi Tony, I'd say it's to do with the video driver settings. Hope that points you in the right direction.

[@tonyscott5045]

Thanks for that Mynda - I'll look into it. I also opened an xls file that was giving me the problem and resaved it as an xlsx file and the problem went away, but other xls files are OK. Strange!

[@MyOnlineTrainingHub]

Oh yeah, you don’t want to be opening it as a .xls avoid that format if possible.

[@hectorbello2104]

Video idea: how to properly drag and drop across different rows when a filter is applied on a table...

[@MyOnlineTrainingHub]

Not a good idea to drag and drop multiple cells on a filtered table.

[@hectorbello2104]

@@MyOnlineTrainingHub exactly my point... it can ruin the data table; hence what is the best approach to address this issue.

[@FrrrrrOshs]

"There's no best way, it's completely up to you"? That's completely wrong. Cut and Copy of formulas have very different "consequences". Not knowing those difference is why I"m on youtube looking for a training video to help my colleague understand why she broke our template.

[@MyOnlineTrainingHub]

I was referring to the "entry points" for cutting/copying/pasting, e.g. to cut you can CTRL+X or you can use the mouse and right-click > cut, or you can use the Home tab > click the Cut icon. That's 3 different entry points for cutting and there's no best way, it's completely up to you. Hope that clarifies things.