Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. 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.
Written by Allen Wyatt (last updated December 16, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
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, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. 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."
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (7735) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. 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.
Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!
Sometimes it is helpful to add annotations to your charts in order to explain the data displayed. This tip provides ...
Discover MoreWorking with elapsed times can be a bit tricky in some situations. One such situation involves the displaying of elapsed ...
Discover MoreWouldn't it be great to have your huge charts print out on multiple pieces of paper that you could then piece together? ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2023-12-18 12:34:47
J. Woolley
For related discussion, see https://excelribbon.tips.net/T003591_Picking_Worksheets_Quickly.html
and https://excelribbon.tips.net/T007094_Jumping_to_a_Specific_Worksheet.html
2023-12-17 17:23:07
Tomek
I think, clicking on the tab for that chart sheet is still easiest, but if there are so many sheets that you don't see all of them, you can right click on the grey area to the left of the tabs and select the sheet or chart in the Activate dialog box that opens.
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 © 2025 Sharon Parq Associates, Inc.
Comments