Picking Worksheets Quickly

Summary: If your workbook contains a multitude of worksheets, the worksheet tabs at the bottom of the program window start to loose a bit of their utility value. If you want a quick way to choose which worksheet to display, apply the technique described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

An Excel workbook can contain almost any number of worksheets, and the tabs for those worksheets are displayed at the bottom of the screen. Everyone knows that if the tabs can't all fit across the bottom of the screen, you can use the navigation buttons in the bottom-left screen corner to scroll through the worksheet tabs.

What you may not know is that Excel provides a cool way to pick a worksheet if you can't see its tab on the screen. (Hmmm; do I scroll left or right? How far do I need to go?) All you need to do is right-click on the navigation buttons. (The navigation buttons appear just to the left of the worksheet tabs.) Excel displays a Context menu that lists all your worksheets. Just pick the one you want, and off you go—no need to worry about which way to scroll!

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2144) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.

Check out ExcelTips: The Macros today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Picking Worksheets Quickly