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.
Sometimes you have more than one workbook open because you need to copy data from one notebook to another or sometimes you simply need to view data from different workbooks, different files, at the same time. It's not uncommon also to have 3 or 4 or 5 files open depending upon your working environment, and you want to be able to switch back and forth between them somewhat coherently too. Now, sometimes the approach is simply to view them all at once if you have only a few open. I've got two open for the moment. Why not simply go to the View tab and Arrange All? When you choose this make sure you uncheck the box for Windows of active workbook if you'd like to see different workbooks. Click OK.
So, that's fast and easy. You can change the zoom factor on either side as needed. If you are copying data, it's not a bad idea to see both of them at the same time. Now, if you have a third file, fourth file, fifth file open you can imagine how the screen space isn't quiet so efficient. When the view is like this by the way if you'd like to simply focus on one of these, for example the one on the right maybe, click the button to maximize this, and the other one is in the background. How do we get back and forth between the two? The standard way by way of the View menu is to Switch Windows, and we see the list of those that are open.
It's not a bad idea to go here once in a while anyway just to take stock of how many workbooks you do have open, but this is certainly okay and it works fine. A lot faster and particularly efficient if you have only two files open is Ctrl+Tab, back and forth a nice toggle when you have only two. You've got three or four it still works, but it will take you to the next file, the next file and back to the current one. If you'd like to create a new workbook, there certainly are command ways to do this, but Ctrl+N is pretty fast. Ctrl+N, new workbook. It will be called Book2, Book3 depending on which other workbooks you might have had opened recently.
So, here is Book4, and as I press Ctrl+Tab, we are back to this workbook. Ctrl+Tab again and Ctrl+Tab again. So, we can easily zip back and forth between them. If we were to arrange all of them here too that might make some sense. You might want to reconsider possibly Horizontal, Vertical. Tiled is the one I prefer. It usually works out best, click OK, but you can change that as you wish. This display here if you want one of these to be more prominent to get the line sure of attention. Click in that particular workbook and then press Arrange All again and that one will get the lion's share of attention.
Whenever there is an odd number one will be bigger than the others. So, good quick ways to zip around between open workbooks.
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.