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

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.

Check out Filing Your Income Taxes Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using Go To to Jump to a Chart Sheet