Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Microsoft Excel 2016 training tutorial video, learn how to cut, copy and paste data in your Excel spreadsheet.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016. In this section we’re going to take a look at Cut, Copy and Paste.

Now the first thing I need to point out is that Cut, Copy and Paste work to some extent in a similar way to the way that they work in other Windows applications but there are quite a few additional features or shall we say specific features of Excel that you need to be aware of. So what I’m going to go through first is some pretty straightforward examples of Cut, Copy and Paste and I’ll point out many of those features as we go. You can Copy, Cut, Paste individual cells, whole rows, whole columns, any combination of cells, rows and columns, and in fact you can Copy, Cut and Paste whole worksheets, including between workbooks.

So let’s just take a straightforward example. Let me just select the cells from M9 down to M14. There’s a number of ways of doing that. Of course one way of doing that is to click on M9, keep the mouse button down, drag down to M14, and then I can just copy.

Now on the Home Tab in the Clipboard Group there’s a Cut and Copy button available to me. There’s no Paste at the moment because I haven’t got anything on the Clipboard. But if I just click the Copy button I’ve copied the selection there to the Clipboard. Note the little marching ants round there. And if I select a similar range of cells here, of course the Paste button is activated in the Clipboard Group and I can simply click on Paste and the contents of the selected cells are pasted.

Now of course as usual because that column is too narrow you can’t see that that’s correctly pasted. So if I select column H I could, for example, go to the Format button and say AutoFit Column Width and it will AutoFit that column to the pasted content.

Now one very important point to note here is that the marching ants are still marching. So that selection is still inforce and the content is still on the Clipboard. So if I want to Paste it somewhere else I can.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.