Monday, November 23, 2009

Jumping to a specific worksheet:

If you have a huge number of worksheets in a workbook, you may be looking for a way to jump to a specific sheet rather easily.
If you know the name of the worksheet you want to jump to, you can also use the Go To capabilities of Excel. Follow these steps:
1. Press F5. Excel displays the Go To dialog box.
2. In the Reference box, enter Sheet83!A1. (Replace "Sheet83" with the name of the worksheet you want to jump to.)
3. Click OK.

No comments: