Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table of Tabs
Trying to create a "table of contents" of all my tabs in a worksheet. I've
seen this on other worksheets as a hierarchy list of tabs on the left of the screen... like a folder view... any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table of Tabs
You can type your table of contents entries, then one by one create
hyperlinks to the sheets. Right click the entry and select hyperlink, then click the bookmark button and select the corresponding sheet. This is manual but fast if you don't have a large workbook. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table of Tabs
Rather than an index sheet with hyperlinks.......how do you get back to the
index sheet?.............try a sheet navigation toolbar or similar. Sheet navigation bar from Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro which I prefer. See this google search result for Bob's code. http://tinyurl.com/yoa3dw Don't forget..........right-click on any of the navigation arrows at lower left will give you a 15-sheet list and "more sheets" to pick from. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 11:58:01 -0800, Cyclewench wrote: Trying to create a "table of contents" of all my tabs in a worksheet. I've seen this on other worksheets as a hierarchy list of tabs on the left of the screen... like a folder view... any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table of Tabs
David MacRitchie has a Build Table of Contents macro, available he
http://www.mvps.org/dmcritchie/excel/buildtoc.htm Hope this helps. Pete On Jan 17, 7:58*pm, Cyclewench wrote: Trying to create a "table of contents" of all my tabs in a worksheet. *I've seen this on other worksheets as a hierarchy list of tabs on the left of the screen... like a folder view... any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using auto-fill to populate a table using data from several tabs | Excel Worksheet Functions | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
seperate details in different tabs based on row in pivot table | Excel Discussion (Misc queries) | |||
How can I list worksheet tabs as a table of contents? | Excel Worksheet Functions | |||
How do pivot table source fields automatically create tabs | Excel Worksheet Functions |