Using Go To to Jump to a Chart Sheet

Summary: Using Go To with a cell reference on a different worksheet is a great way of jumping somewhere. Using Go To with a chart sheet is impossible, however, because there are no cells on the sheet to reference. There are workarounds, however, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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:

Press F5. Excel displays the Go To dialog box. (Click here to see a related figure.)
In the Reference box, enter MySheet!A1. (Replace "MySheet" with the name of the worksheet you want to jump to.)
Click OK.

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:

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 (3124) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using Go To to Jump to a Chart Sheet