Tips for navigating between workbooks


show more Tips for navigating between workbooks provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Tips for navigating between workbooks

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

Tips for navigating between workbooks
Video duration: 3m 48s 3h 43m Intermediate

Viewers:

Tips for navigating between workbooks provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

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