Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you want to change the location of a worksheet within a workbook, it's simply a matter of dragging that worksheet. For example, I want to have this current worksheet here, HR List, to appear after the Profits sheet. Simply, drag the sheet tab at the bottom of the screen, drag it to the right. Certainly, you can drag it left throughout as well as needed. Position it wherever we wish. Copying a worksheet is often started by right- clicking a sheet tab, going into Move or Copy. And although this is not incorrect, there is a much faster way to copy a worksheet.
So imagine for example that this project budget 2012, I want to make a copy of this and turn it into the budget for 2013, but rather than copying and pasting data, I'm about to copy the worksheet, simply by dragging this with the Ctrl key held down. A tiny little plus appears in the icon. I'll drag it to the right and let go with the mouse. It could hardly be faster. These two worksheets are identical in all respects except for the name. So if I'm going to be working with the two, ideally I would change the name of the second one pretty rapidly, just by double- clicking. Maybe change that 12 to become a 13.
Get rid of the parenthesis out there on the suffix and we're all set. There might be times also when you want to move or copy a worksheet to a different workbook. I have another workbook opened, so I'm going to go the View tab and choose Arrange All. And if you'd like to see multiple workbooks, make sure you uncheck if it's checked, the box indicating windows of active workbook. Uncheck it. Click OK. Now we see portions of two different workbooks. If I went to move this particular worksheet here to another workbook, I'll simply drag the sheet into the other workbook. That's it.
We have moved it. If you'd like to make a copy, suppose I want to make a copy of this budget here, drag this, and as you might imagine, hold down the Ctrl key. There's that little plus inside the icon. Drag it into the other workbook, positioning it wherever we want. Be sure to let go of the mouse first. We've made a copy of the sheet. So in different ways, we can copy worksheets much, much more efficiently, simply by dragging with the Ctrl key, and moving sheets of course is a simple drag. Both techniques are widely used as you work with Excel, particularly when you have to deal with worksheets, along with different workbooks you're trying to get data back and forth quickly.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64698 Viewers
80 Video lessons · 124318 Viewers
52 Video lessons · 60253 Viewers
59 Video lessons · 46084 Viewers