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.
You can navigate through a workbook pretty fast with a lot of keystroke shortcuts and techniques. In this particular workbook there are quite a few worksheets. One of the first things you might consider doing when you do see a workbook that perhaps you've never seen or maybe this is one you haven't seen in a long time. In the lower left-hand corner these so called navigation arrows do have a purpose. I am about to click the one right here that's third from the left. It's going to move the display slowly to the right to allow us to see more sheet names or click the one to the left.
I wouldn't exactly call this a shortcut. It isn't really. A better idea to get oriented with the workbook is to right-click these arrows and then get a vertical list of the sheet names. The top down order there corresponds with the left or right order that we see at the bottom of the screen. Many times you will be able to see more sheet names this way than you will across the bottom. It depends upon the sheet length. So, not only can we see the names, but we can use them as a go-to sort of vehicle. I want to go to the MixedNames sheet. There it is.
Click it. Or maybe I've check this out a little bit. I'll right-click it here. I want to go to the ProjBudget2011 here. Or right-click and so on. You can easily move around that way. Now, you can also in the display at the bottom of the screen see more sheet names. Let me scroll so we can have some white space here. At some point the sheet names end and the scrollbar begins. But do we really need a scroll that's that wide? If we put the mouse right at this juncture, we can click and drag and make the scrollbar substantially smaller.
It is still functional. Now, depending upon the number of worksheets that we have here you might not see them all, but you have a greater likelihood of seeing most of them in this kind of display. Now, if I click the extreme left arrow over here, that's the very first sheet. Perhaps we are not seeing them all here, but we are seeing most of them, and that's pretty handy at times. On this right-clicking of the navigation arrows, do note that you might see More Sheets. At most we'll see sixteen names here. So, if you have more than sixteen you won't see them all.
We have to click More Sheets and then into this dialog go find the others. So, it's not quite so efficient and smooth under those circumstances. When your hands are on the keyboard if you want to switch worksheets, it's Ctrl+Page Down to the one sheet to the right. Ctrl+Page up, and as you look at the sheet tabs at the bottom you see what's happening here. I think this is most useful when you have a workbook where the order of the sheets is pretty obvious. For example January, February, March. When you are on the March sheet there is no doubt that April is the next one over. You'll press Ctrl+ Page Down without even looking.
At other times now the mouse might be faster. At some points if you would like to go to the very last sheet, if you simply hold down and Ctrl+Page Down together, within a second or two you'll viewing the last sheet or trying to go to the first sheet, hold down Ctrl+Page Up and within a second or two depending on the number of sheets you'll be viewing the first sheet. What if you need to add a new worksheet to this workbook? At any given point, you are looking at a certain sheet perhaps, you say "I want a new sheet" and think of it as inserting a column or in a similar lane.
I want a new sheet to the left of this. Shift+F11. There we go. You might also notice if you are viewing the last sheet names here there is an indicator after the very last sheet name, and if you point to it, it will Insert Worksheet (Shift+F11). Now, if you happen to click this it will put a new sheet after the last one. But you can use Shift+F11 in another situation. Again, here this will put a new sheet to the left of the current worksheet. So, a variety of techniques here from moving through the various sheets of a workbook and also controlling the creation of new ones.
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.