Thread: Switchboards
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Switchboards

Hi Brian,

I think the easiest way is to...

1. Insert a new worksheet.
2.If the new worksheet is not already the first worksheet then click
and drag its sheet tab to the left to get it there.
3.Convert this new sheet to act like a table of contents by inserting
Hyperlinks into a number of its cells. For example, click a cell on the
new worksheet, the following steps will place a hyperlink in that cell
which will take you to sheet2...

a) go Insert|Hyperlink

b) in the Insert Hyperlink dialog click on "Place In This Document"
under the "Link to:" heading

c) in the "Or select a place in the document" box click on "Sheet2"

d) Edit the value that appears in the "Text to display" box to what
ever you want to appear in the cell on sheet1, the table of contents.

e) Click OK

Now when you click on that cell you will be taken to sheet2.

Just repeat this process for each of your worksheets

You could also reserve a cell on each of you sheets for a hyperlink to
take you back to the table of contents sheet.

Ken Johnson