How Do I Hyperlink to a Hidden Worksheet?

Microsoft Excel 2010 can "unhide" worksheets to display data in a workbook.

Microsoft Office 2010 can insert a hyperlink that opens or jumps to another file for additional information. MS Word, Excel and PowerPoint contain a "Hyperlink" button on the command ribbon. For example, inserting a hyperlink in a Word document can link to an Excel workbook as a reference. A workbook can include displayed or hidden worksheets. When you activate a hyperlink to a workbook, you can then "unhide" a worksheet to display data.

Instructions

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

1. Point the cursor over the hyperlink. The ScreenTip will display instructions for following the link.

2. Press the "Ctrl" key and click the hyperlink. The Excel workbook opens.

3. 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.

4. Click "Unhide." A small dialog box opens with a list of hidden worksheets.

5. Click to select the worksheet in the "Unhide sheet" text box.

6. Click "OK" to unhide the worksheet. The dialog window closes. The Excel worksheet appears on the screen.

Tips & Warnings

• To insert the hyperlink, you can also click the "Insert" tab on the command ribbon. Click the "Hyperlink" button in the "Links" group. The "Insert Hyperlink" dialog window opens.

• Excel contains a "Format" button in the "Cells" group on the "Home" tab. This button includes the "Hide/Unhide" option in the "Visiblity" section.

References

• Microsoft Office: Word 2010, Create, Format or Delete a Hyperlink
• Microsoft Office: Excel 2010, Hide or Show Worksheets or Workbooks
• Microsoft Office: PowerPoint 2010, Create a Hyperlink