课程: Excel Essential Training (Microsoft 365)

Moving, copying, and inserting data

课程: Excel Essential Training (Microsoft 365)

开始一个月试用

Moving, copying, and inserting data

“

- [Instructor] Simple thought that occurs to us as we work with not only Excel, but also Word, PowerPoint and other software packages is this idea of I will not repeat or retype something that's already there. We often will copy data, copy information. As we look at this worksheet called Move-Copy-Insert. We might want to make a copy of this data using some different numbers. So possibly we'll highlight this portion of it. And if you have worked with other software, you're familiar with the two-step process of copy and paste. And if you're moving it, cut and paste. if I want this to also appear down in row 20, instead of copying it and pasting it, which certainly isn't wrong, I can point to any edge here and drag it. If I hold down the Control key as I do this, a tiny little plus is accompanying the arrow. As we start to drag down a little bit here, automatic scrolling occurs, get right to this location. I'll release the left mouse button. Then the key, we simply made a copy of the data and of course, at other times, instead of doing that, I'll press Control + Z. We simply want to move data. Now, it's less likely to move it in this particular worksheet here but with the data highlighted, point to any edge, drag it down, put it there. Could have dragged it right, although that would disrupt the headings. But you can easily move data unless you're moving at a few hundred rows, for example. So the two-step process, although widely used and it works fine, it's often a lot easier simply to drag data, drag it from any edge once it's highlighted. And again, if I wanted a copy of all of this, I can point to any edge, say the right edge, hold down the Control key, drag it down here, let go of the mouse first and there's a copy of it. There also could be times too when you want to insert data. Not so well-known is a drag along with the Shift key. Now, as you look at this data here, sales, expenses, profits, down here, we're analyzing the percent of sales change, but for some reason, profits here is appearing before expenses. It should be the other way around. So one approach could be we could insert new cells right here. Imagine a bunch of empty cells above this and then move the data below it up. But it's going to be a lot simpler to simply, for example, highlight just these cells here. And with the Shift key held down, we can drag this upward. Let go of the mouse first and we simply have moved and inserted. And you can do that with columnar data as well too. Entire rows, entire columns or just cells within rows or columns. So as it turns out in this list here, which is going to be expanded and I'll be copying data from other sources too. I want the department to be to the left of the building column or phrased another way, I want building to be to the right of department. It makes no difference. We'll simply click the entire column letter and I can drag any edge here, but I'll point to the left edge, hold down the Shift key, drag leftwards using the left mouse button right to here. Release the mouse first, and we simply moved and inserted the data. You want to have that increasing feeling that you're in control, and you've got tools here to move data around in sensible ways, either copying data, moving data or when necessary, moving and inserting data. Excel has all the tools for redesigning worksheets without heavy command usage. And in these techniques here, we didn't use any of the commands that we could have used possibly off of the Home tab. These were all dragging techniques and easily achieved by using either the Control key or the Shift key as we saw in those two examples. Or in the case of move, a simple drag.

内容