Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks to create an index
I'm trying to learn hoe to use a hyperlink to create a worksheet index. In
one spread sheet I've got about 35-40 tabs, thus the index idea. Additionally, does anyone know how I can make my index always the sheet that excel opens to upon opening this workbook. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks to create an index
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) And you have another response at your other thread. Jason - MR wrote: I'm trying to learn hoe to use a hyperlink to create a worksheet index. In one spread sheet I've got about 35-40 tabs, thus the index idea. Additionally, does anyone know how I can make my index always the sheet that excel opens to upon opening this workbook. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing hyperlinks | Excel Discussion (Misc queries) | |||
Picture hyperlinks don't work when publishing to web...? | Excel Discussion (Misc queries) | |||
how to create multiple hyperlinks within a dropdown list | Excel Discussion (Misc queries) | |||
CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
Hyperlinks and sorting data | Excel Discussion (Misc queries) |