Browse » Home
Monday, March 11, 2013
How Do I Hyperlink to a Hidden Worksheet?
Insert the Hyperlink
1. Open the Microsoft Office document.
2. Click and drag the cursor over the text or image where you wish to insert the embedded hyperlink.
3. Right-click the selected text or image to show a list of commands, including 'Hyperlink.'
4. Click 'Hyperlink.' The 'Insert Hyperlink' dialog window opens. You can also click the 'Insert' tab on the command ribbon and click the 'Hyperlink' button in the 'Links' group.
5. Click the 'Existing File or Web Page' button in the 'Link to' list.
6. Click the 'Recent Files' button to the left of the text box.
7. Click the Excel file from the list.
8. Click 'OK.' The hyperlink appears on the document.
Unhide the Excel Worksheet
9. Point the cursor over the hyperlink. The ScreenTip will display instructions for following the link.
10. Press the 'Ctrl' key and click the hyperlink. The Excel workbook opens.
11. Right-click any sheet tab near the bottom of the screen. For example, 'Sheet 1' or a named worksheet tab. A list of commands appears.
12. Click 'Unhide.' A small dialog box opens with a list of hidden worksheets.
13. Click to select the worksheet in the 'Unhide sheet' text box.
14. Click 'OK' to unhide the worksheet. The dialog window closes. The Excel worksheet appears on the screen.