Click and drag cells to move them to a new location. By using the Ctrl key, you can drag cells to copy them. By using the Shift key, you can drag cells to move and insert to a new location.
- [Instructor] No matter how a worksheet looks, you can easily change its appearance by making a copy of data, sometimes you want to move data. And at other times, you actually want to move and insert data at the same time. On this worksheet called Move-Copy-Insert, in the workbook 05 - Layout, we've got two sets of data. And for the information on the left-hand side here, I like the look of it, except I want to move this portion of it, as I click and drag across, I wanna move this down a row or two. Although you can use traditional cut and paste methods, often, moving data is simply a one-step process after you select the information.
Highlight the cells you want, drag an edge. You can drag any edge, example here, I'll drag the right edge down, let go of the mouse. Everything has been moved down. There are formulas in this list. There's a formula here, for example, we didn't look at it earlier, now it says, you can see in the formula bar, C5 minus C6. Formulas adjust automatically, so at different times you might want to move data. If I want the information off to the right to be moved closer to this data, I could highlight it and drag it to the left, or possibly insert new columns.
I don't need to do that just yet, but we always wanna have this sense that we can move the information around. And unless we're moving this many hundreds of rows away, why not highlight the data and simply drag it. Once again, I'll do this with the data over here. Highlight it, drag it down two more rows. Maybe that's a bit too much, I'll drag it up a few rows. You wanna have the sense you can do this quickly and easily. At other times, you might want to make a copy of the data. Maybe these numbers are predictions and I wanna make a copy of these or maybe I wanna copy this and turn it into the second half of the year.
How do we make a copy of the data? After highlighting cells, drag an edge just as if we were moving, but in the process hold down the Control key. And as you hold down Control, the arrow that you're using to drag is now accompanied by a plus. So we're dragging this to a new location, maybe down to here, at some point we let go of the mouse first, and that's critical. Let go of the mouse first and then the key. We've simply made a copy. And those formulas that we see, for example, the one right here in cell B24 now, is subtracting these two cells.
So we've simply made a copy of the data. So at different times, either we move data by dragging an edge of the highlighted area, or using the Control key we make a copy. And always remember to let go of the mouse first. Sometimes you want to move data and insert. In the data that we're seeing at the top of the screen, you might notice something that's a little bit off. We see Sales, Expenses, and Profits in cells A4, five, and six, but down here we're analyzing the sales change. And then for some strange reason we've got Profits here and Expenses here.
That's not really consistent, so what do we need to do here? Well, one thought, and this is okay but not the best, we could highlight these cells, insert cells, push everything down, then take this information and move it up and then get rid of the empty cells that we created. Why not just do this in a single action? I don't want to move anything to the right, so I've got these cells highlighted. I'm going to point to the top edge here. And now, as I drag upward, I've got the Shift key held down. Move up to here, let go of the mouse first.
So a move and insert at the same time, we sometimes refer to as a Shift-Drag, we hold down the Shift key. We can do this with columns, too. So in this list off to the right, for whatever reason, I want the higher date in the years to appear to the left of the department. I can do this for one column or multiple columns. Highlight both of these and I'll drag leftward, this time with the Shift key, drag here, let go of the mouse first, I moved the two columns leftward.
We can do this with multiple columns or multiple rows. 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 redesign the look of it, move those columns leftward or rightward as necessary, move those rows up and down, or move and copy data simply by dragging or dragging with the Control key. Or in that one special example, dragging with the Shift key as well to move and insert.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros