Viewers: in countries Watching now:
In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course.
When you have more than one workbook opened at a time, you need efficient ways to move back-and-forth between them. The standard approach and always recommended for the fact that it does remind us what we do have open is located on the View tab in the Ribbon. Extreme right location here in the Window group. Switch Windows. A good idea to click here once in a while just to remind yourself that you do have more than one file opened and this is the standard way to switch files for sure. Makes good sense to take stock of that from time to time anyway.
But it's certainly going to be faster if you press Ctrl+Tab. Now, Ctrl+Tab might not take you to the file that you want but eventually it will if you keep pressing Ctrl+Tab. This will toggle so to speak between all opened workbooks that we might have and then back to the current one. Now, if you do that frequently, you are used to the order, you know which direction these are headed in. If you somehow think of them as clockwise or counter-clockwise, you just have this image in your mind. You can reverse directions by pressing Ctrl+Shift+Tab.
It will go in the opposite direction. That's a little bit hard to remember at times. It is worth noting that when you have only two files open, Ctrl+Tab of course is a toggle and a very fast switch to move back-and-forth between opened workbooks. You can also use Ctrl+F6, not that it's any better. The only advantage here could be that this is exactly what we use in Microsoft Word as well. Ctrl+Tab doesn't work there. So Ctrl+F6 is the more universal way of switching windows, it's the way it's typically described, or Ctrl+Shift+ F6 to move the opposite direction.
But if you use this mostly for Excel, Ctrl+Tab is the fast way to get there. I use it all the time and even when I want to know which files are open rather than going into the menu, I'll simply press Ctrl+Tab a few times, take quick stock of what's open, and back here, ready to do what I want to do. Fast and easy way to navigate through multiple opened workbooks.
There are currently no FAQs about Excel 2010: Managing Multiple Worksheets and Workbooks.
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.