Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switchboards
Is it possible to create a switchboard in Excel worksheets in a similiar
manner to the switchboards generated in Access to allow easy navigation of a workbook? thanks Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switchboards
Hi Brian, Just discovered you can insert a hyperlink onto a shape such as a textbox or any of the autoshapes such as the rectangle with rounded corners. Just in case you prefer buttons with normal looking text to cells with blue hyperlink text. Also, I access these discussion groups via Google Groups, which has a facility for searching the group for certain topics. I did a search for "Table of contents" and it came up with over 600 items. You might want to check that out. Ken Johnson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switchboards
Give this site a try...
http://www.mvps.org/dmcritchie/excel/buildtoc.htm -- Mark Ivey "confused teacher" wrote in message ... Is it possible to create a switchboard in Excel worksheets in a similiar manner to the switchboards generated in Access to allow easy navigation of a workbook? thanks Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making switchboards and linking buttons in excel | New Users to Excel |