Anne Troy
02-19-2003, 03:32 AM
Create a Table of Contents (TOC)? Are you crazy?
A whole lot easier than you think.
On your first sheet—your TOC—type each sheet’s name. Select the cell that you typed the first name in. Hit Insert-Hyperlink. Choose "Places in this document" and you'll be provided a list of the worksheets.
This is an especially nice method to use if you’ve hidden your sheet tabs for other purposes. Put a nice big title for your workbook above the TOC. Then hit Tools-Options, View tab and uncheck Gridlines.
If you want to hyperlink to a location in a Word document from Excel, you don't get the option to choose bookmarks, but it works just the same as it does in Word. A hyperlink in Word to a bookmark called "Hello World" will look like this in Excel:
...path\test.doc#HelloWorld
You may not be able to choose a Word document, and then choose the bookmark button, but you can type it in as shown.
A whole lot easier than you think.
On your first sheet—your TOC—type each sheet’s name. Select the cell that you typed the first name in. Hit Insert-Hyperlink. Choose "Places in this document" and you'll be provided a list of the worksheets.
This is an especially nice method to use if you’ve hidden your sheet tabs for other purposes. Put a nice big title for your workbook above the TOC. Then hit Tools-Options, View tab and uncheck Gridlines.
If you want to hyperlink to a location in a Word document from Excel, you don't get the option to choose bookmarks, but it works just the same as it does in Word. A hyperlink in Word to a bookmark called "Hello World" will look like this in Excel:
...path\test.doc#HelloWorld
You may not be able to choose a Word document, and then choose the bookmark button, but you can type it in as shown.