Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
Copying and moving data is something that most Excel users do frequently, and many times it's a multi-step process. It's a copy-paste or a cut and paste, but much of the time, it can be a simple drag in the good sense. I want to take this data here for example and move it somewhere else. Now, if I don't have to drag these 3000 rows, why not just after highlighting it, drag any edge? Put it here, put it there, put it here or whatever. Fast and easy. And many, many times that's the best way to go.
Once you become familiar with that technique, of course, you use it in other senses too. If we wanted to put in quarterly totals here, rather than inserting cells, why not just highlight these, drag this down, and then put in our quarterly totals there? Do the same thing on the other side as well. So, it's fast and it's easy much of the times simply to drag data. Now if there were formulas here, I'm just going to click here and click AutoSum, if we move this data, the formulas travel with it and they remain associated with this data. So if we put this here for example dragging it and do a quick adjustment of the column widths by double-clicking, but we do see here that the formulas relate to this data, as you would hope and expect.
So moving data many, many times is fast and easy, simply by dragging. If we want to work with this data and maybe we don't want to disrupt it at the same time, what we often will do is copy data and many times the process is almost the same. Drag the data, but this time maybe hold down the Ctrl key. Now, as you hold down the Ctrl key, a subtle difference on the screen, a tiny little plus accompanies the arrow as we drag this. When you are holding down the Ctrl key and dragging data to copy it, be sure to let go of the mouse first.
Try that a few times, and it makes perfect sense. And as you do this, if you occasionally let go of the Ctrl key too fast or the mouse too fast, just press Ctrl+ Z to undo. Try it over again. It's fast and it's easy. Another way to copy and also to move is simply after selecting the data, point to any edge and drag with the right mouse button. You may drag here, and as we let go, there's move, there's copy, whichever one we need. It works that way too. So that's a slightly safer and then you don't have to hold down any keys if you're doing that.
There might be times too when you want to move data to another worksheet. Now if you only do this occasionally, you might as well use one of the standard techniques possibly. Right-click and copy and then go to the destination, right-click and paste, or if it's a move, right-click and cut and paste and so on. But you can also drag data to another sheet, if you hold down the Alt key. So I'm holding down Alt right now. As I drag on to sheet3, I have let go of all now and I'm going to put it up there, so you can do that sort of thing too.
You can imagine here too if that's a move, as it was here, what if you wanted to copy the data? Same idea. We'll be holding down Alt, but if it's going to be a copy, we'll also hold down the Ctrl key. And there's that little plus associated with it. So I might go to a different sheet here. Come over here, let go of the mouse, and now we've made a copy of the data as we put it on another sheet and so the original was still there. So it's copy, right back here. So different techniques here for copying and moving data within the same worksheet or across different worksheets.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.