Navigating between open workbooks


show more Navigating between open workbooks provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Managing Multiple Worksheets and Workbooks show less
please wait ...

Navigating between open workbooks

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-c...

Navigating between open workbooks
Video duration: 2m 4s 1h 29m Intermediate

Viewers:

Navigating between open workbooks provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Managing Multiple Worksheets and Workbooks

Subject:
Business
Software:
Excel
Author:
please wait ...