Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
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.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.