Join Dennis Taylor for an in-depth discussion in this video Moving, copying, and inserting data, part of Excel Essential Training (Office 365).
- [Instructor] If you work with Microsoft Excel for any length of time or perhaps with Microsoft Word, you've come to appreciate the value of copying by a two step process, copy/paste or moving data by a two step process of cut and paste. But many times after selecting data, a simple drag will let you move or copy data easily. Looking at a worksheet called Move Copy Insert. It's in the workbook 05 layout. I'd like to make a copy of this data and experiment with some of the numbers. Or maybe I wanna make a copy of the data and do it for the second half of the year.
So I've got all this data high-lighted like this. So rather than doing a copy paste, which certainly isn't wrong, I'm just going to point to one of the edges here and start to drag. Now, at some point in the process a tiny little plus accompanies that arrow. So a so called control drag, that's what I'm doing right now. I drag the data down here, let go of the mouse and there's a copy. The formula right here in cell B21 refers to those 2 cells, not the ones up above, so formulas generally are not a problem when you copy data. Now I'm gonna undo that, control z.
Sometimes you simply want to move data. And unless you're moving hundreds of rows, many times it's gonna be easier simply to drag data, similar to what we just did on the copy. This time we hold down no keys on the keyboard. We got our data high-lighted. We drag an edge. We'll put it there, or over there if the case more appropriate. Fine, we move it wherever we want. And that's generally the easier way to do it. Now if you look at this worksheet for a bit, something is a little bit off. You've got Sales, Expenses and Profits in rows four, five and six. And here we're analyzing the sales change, but somehow or other, this is profits and this is expenses.
Now a standard technique here would be, what? To insert some new cells above this? No. One option could be we could take this data, move it down, then move the expenses up. And why not do this in more or less a single action after selecting the data? You can move and insert by dragging data with the shift key. So I like to drag this data upward, put it between rows nine and 10, but I'll be holding down the shift key as I do this. Got the shift key held down. I'm dragging the top edge upward. Let go of the mouse first.
And there we are. A move and insert. And I've got some data off to the right and for whatever reason, I wanna move some of that in a similar way. I want the hire date to be to the left of the social security number column. So I click column Q. I'm gonna be dragging the left edge. I've got the shift key held down and drag it this way. So you can drag left or right. You can do it with multiple columns. It just saves time, so you don't have to insert new columns, move and delete and so on. And so the more you get comfortable with these commands, the more you have the sense that no matter how the worksheet looks, you can easily re-design the look of the worksheet layout by moving data, copying data, or in some cases, moving and inserting data at the same time.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.