| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Many sheets in a file - can they be shown in more rows
Working with manu sheets in the same Excel-file, I'm loosing the overview a
bit when some of the sheets can be shown - can the tags/sheetnames be shown in more than one row? -- Best from Bjarne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many sheets in a file - can they be shown in more rows
Hi Bjarne
Maybe you like this http://www.contextures.com/xlToolbar01.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bjarne Krog" wrote in message ... Working with manu sheets in the same Excel-file, I'm loosing the overview a bit when some of the sheets can be shown - can the tags/sheetnames be shown in more than one row? -- Best from Bjarne |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many sheets in a file - can they be shown in more rows
You can right-click on the navigation arrows at lower left end of sheet tabs
bar and get a list of 15 sheets and "more sheets" to select from. Or you can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's site to which Ron pointed you. Or my favorite...........see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Mon, 20 Oct 2008 03:58:02 -0700, Bjarne Krog wrote: Working with manu sheets in the same Excel-file, I'm loosing the overview a bit when some of the sheets can be shown - can the tags/sheetnames be shown in more than one row? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many sheets in a file - can they be shown in more rows
Hi Gord - thx for info.
-- Best from Bjarne "Gord Dibben" skrev: You can right-click on the navigation arrows at lower left end of sheet tabs bar and get a list of 15 sheets and "more sheets" to select from. Or you can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's site to which Ron pointed you. Or my favorite...........see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Mon, 20 Oct 2008 03:58:02 -0700, Bjarne Krog wrote: Working with manu sheets in the same Excel-file, I'm loosing the overview a bit when some of the sheets can be shown - can the tags/sheetnames be shown in more than one row? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many sheets in a file - can they be shown in more rows
Hi Ron - thx for the info.
-- Best from Bjarne "Ron de Bruin" skrev: Hi Bjarne Maybe you like this http://www.contextures.com/xlToolbar01.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bjarne Krog" wrote in message ... Working with manu sheets in the same Excel-file, I'm loosing the overview a bit when some of the sheets can be shown - can the tags/sheetnames be shown in more than one row? -- Best from Bjarne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| Excel file 4MB.Copied sheets to a new file.Now=64Kb-easier way? | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Linear Mode
