Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Using Go To to Jump to a Chart Sheet.
When you want to jump to a specific worksheet in a workbook, you can use the Go To feature of Excel to make the jump painless, in the following manner:
This works great for regular worksheets, but it won't work if you want to jump to a chart sheet. Why? Because Go To is used to jump to specific cells (in this case, cell A1 on MySheet), and chart sheets have no cells you can reference.
If you want a quick way to jump to a chart sheet, you will need to resort to a macro. You can have the macro ask for a chart sheet name, and then use the Activate or Select methods with the sheet name. The pertinent line of the macro—the one that does the actual "jumping"—can be either of these:
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Sheets("MyChart").Activate
Sheets("MyChart").Select
All you need to do is substitute the proper name of the chart sheet in place of "MyChart."
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (7735) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Using Go To to Jump to a Chart Sheet.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Adding labels to a chart can make the information presented in the chart more understandable. Excel allows you to add ...
Discover MoreExcel allows you to create custom chart formats that go beyond the standard formats provided in the program. These custom ...
Discover MoreIt can be frustrating when Excel doesn't display the formatting options that you know it should for your charts. This tip ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-05-03 09:24:34
Joseph
There is another method that I have been using.
In the extreme lower left-hand corner of any work sheet are two arrows (pointing left and right, to move forward or backward among all sheets.)
Right-click and a list of all the worksheets in your workbook will be displayed. Choose the one you are searching for and it will be displayed.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2017 Sharon Parq Associates, Inc.
Comments