Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Navigating through Multiple Worksheets
Hi, I've created a pricelist for my company and it has about 35 different
worksheets. Question: Is it possible to create some type of table of contents that will allow users to easily jump to and from specific worksheets without having to scroll through all the worksheet "tabs" ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Navigating through Multiple Worksheets
Yes. You can either do this manually by going to Insert--Hyperlink and
selecting a named range for each worksheet in your workbook, or, if there are too many worksheets for that to be a viable solution you could run a macro to automatically create one: http://www.mrexcel.com/tip017.shtml Dave -- Brevity is the soul of wit. "Shayra" wrote: Hi, I've created a pricelist for my company and it has about 35 different worksheets. Question: Is it possible to create some type of table of contents that will allow users to easily jump to and from specific worksheets without having to scroll through all the worksheet "tabs" ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Navigating through Multiple Worksheets
The free Excel add-in XLExtras will do that.
It adds an item "Table of Contents" to the Insert menu. Each sheet name is hyperlinked to the actual sheet. No return hyperlink is provide however. It will do other stuff including sorting workbook sheets. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Shayra" wrote in message Hi, I've created a pricelist for my company and it has about 35 different worksheets. Question: Is it possible to create some type of table of contents that will allow users to easily jump to and from specific worksheets without having to scroll through all the worksheet "tabs" ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |