Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you're adept at manipulating worksheet data, it's pretty straightforward process. If you look at the information in row 12 for example, you might be looking at this and saying, this really belong between rows 10 and 11 as we see the data right now. Over in column A we've got Sales, Expenses and Profits in rows 4, 5 and 6, but down here it's Sales, Profits and Expenses. That's probably not the right order. So, we'd like to take this data and put it above the row that's right above it, Profits. The standard way to do this would be to insert a new row above row 11, move this up and then get rid of the empty row, something along those lines.
Why not make it be just one step? This data is highlighted. We're going to drag this upward by dragging either the top or the bottom edge, doesn't make any difference, while holding down the Shift key. Now, there's a little I-beam indicator. I don't want to put it up here, but now you can see that perhaps a bit more clearly. The Shift key is being held down. I'm dragging, want to stop right there, let go with the mouse and it simply repositions the data. Fast and so easy, and you can imagine doing this in other situations as well, maybe you're about to use this list here for data validation purposes and you've recognized that there are many manufacturing people, and that name might occur so often, you do want to have it at the top of the list and leave the remainder of it alphabetize.
So, let's just put this on top here. I want to drag this upward with the Shift key held down, and now we don't want a gaping hole in the bottom and we won't have that either. I'm going to drag this upward to the top, right there, let go the mouse first, and we've repositioned the word Manufacturing. There's no gaping hole down below. It's fast, it's easy, and we can do this with columns as well. Maybe we've decided that the Phone column belongs to the left of the Social Security column, and we could move either one. It doesn't make any difference.
We'll just pick the Phone column. Click column E. It can be the whole column. Why not? Drag the left edge or right edge. I'm going to drag the left edge and once again hold down the Shift key, drag it over here, let go of the mouse, and we've moved the entire column. Now, strangely enough if you look down the bottom here, it looks like it's not all highlighted, but it did take place. I guess we assume that's just a design flaw here, but it does work perfectly. We can also move columns across multiple columns. It doesn't have to be adjacent data.
Here's column F. Maybe we've decided that that belongs between columns A and B. We'll drag either edge. Maybe we'll drag the right edge. By holding own the Shift key, we're going to put this between A and B. Let go with the mouse first. There we are. Same idea, we've moved the data. Another way to do this by the way is to select the data and drag with the right mouse button, no additional keys required here. Maybe we've decided now it belongs between D and A. We drag this with the right mouse button.
Now question might be at first, do we put this on top of E or on top of D? We can experiment. Let's put it on top of E and when I let go with the right mouse button, here's a pop-up menu. Shift Right and Move. Now, there certainly could be other situations where you might want to do a Shift Right and Copy. I think more commonly Shift Right and Move. So we're about to move the Status data here, and the Shift Right means that's column E data, the Phone data, will bump to the right. Stays in column E because we moved it over.
And either way works efficiently and fast, and you don't have to worry about inserting any new rows or columns as you take these actions. So, some great shortcuts here for manipulating data in Excel. Hold down the Shift key or use the right mouse button as you drag data to move either columnar or row data quickly and easily.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91238 Viewers
80 Video lessons · 138202 Viewers
59 Video lessons · 57030 Viewers
52 Video lessons · 70673 Viewers
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.