Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List box or form
I have an excel file which contains about 30 sheets - I always have trouble
scrolling through them to find my data, is there a way of adding a list box/form that would always be on top allowing me to have links to the pages? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List box or form
hi.
Try this. at the far left bottom of the excel window, right click the sheet(tab) navigatior. you should get a popup showing the sheets. but in your case (with 30 sheets) at the bottom of the popup, it should say "more sheets". clicking that will popup a activations form with all the sheet in the book. click the desired sheet name to go to that sheet. Regards FSt1 "CP" wrote: I have an excel file which contains about 30 sheets - I always have trouble scrolling through them to find my data, is there a way of adding a list box/form that would always be on top allowing me to have links to the pages? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List box or form
Ok thats a great - is there any way to have it permanently there ?
"FSt1" wrote: hi. Try this. at the far left bottom of the excel window, right click the sheet(tab) navigatior. you should get a popup showing the sheets. but in your case (with 30 sheets) at the bottom of the popup, it should say "more sheets". clicking that will popup a activations form with all the sheet in the book. click the desired sheet name to go to that sheet. Regards FSt1 "CP" wrote: I have an excel file which contains about 30 sheets - I always have trouble scrolling through them to find my data, is there a way of adding a list box/form that would always be on top allowing me to have links to the pages? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List box or form
Ignore my last entry - the answer was in "hyperlinked drop down entries"
posted below |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
List box or form
If you rightclick on the VCR like controls (to the left of the worksheet tabs),
you'll see a list of worksheets in that workbook. Other options: Maybe you could use David McRitchie's Build Table of Contents to get the list and the hyperlinks all at once: http://www.mvps.org/dmcritchie/excel/buildtoc.htm Another option if you want a more generic solution: http://contextures.com/xlToolbar01.html (From Debra Dalgleish's site.) It builds a toolbar that you can use with any workbook to navigate to any worksheet. CP wrote: I have an excel file which contains about 30 sheets - I always have trouble scrolling through them to find my data, is there a way of adding a list box/form that would always be on top allowing me to have links to the pages? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling in a form from a list | Excel Discussion (Misc queries) | |||
Mailing list form | Excel Discussion (Misc queries) | |||
Form List Box | Excel Worksheet Functions | |||
Help with Form List Box | Excel Discussion (Misc queries) | |||
Use dropdown list from Form | Excel Discussion (Misc queries) |