Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I have an outline consisting of grouped rows, there is an outline
navigation panel along the left hand side. The user expands or collapses grouped rows using buttons on this navigation panel. Is there a way to hide this navigation panel? Thanks. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In xl2003:
Tools|Options|View tab|Uncheck Outline Symbols Paul wrote: When I have an outline consisting of grouped rows, there is an outline navigation panel along the left hand side. The user expands or collapses grouped rows using buttons on this navigation panel. Is there a way to hide this navigation panel? Thanks. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Beautiful. Thanks!
On Mar 25, 2:42 pm, Dave Peterson wrote: In xl2003: Tools|Options|View tab|Uncheck Outline Symbols Paul wrote: When I have an outline consisting of grouped rows, there is an outline navigation panel along the left hand side. The user expands or collapses grouped rows using buttons on this navigation panel. Is there a way to hide this navigation panel? Thanks. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Paul wrote:
When I have an outline consisting of grouped rows, there is an outline navigation panel along the left hand side. The user expands or collapses grouped rows using buttons on this navigation panel. Is there a way to hide this navigation panel? Thanks. On Mar 25, 2:42 pm, Dave Peterson wrote: In xl2003: Tools|Options|View tab|Uncheck Outline Symbols On Mar 25, 3:10 pm, Paul wrote: Beautiful. Thanks! I don't suppose there is a way to turn off visibility of the outline symbols for row groups while still showing them for the column groups (and vice-versa)? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not that I see.
Paul wrote: Paul wrote: When I have an outline consisting of grouped rows, there is an outline navigation panel along the left hand side. The user expands or collapses grouped rows using buttons on this navigation panel. Is there a way to hide this navigation panel? Thanks. On Mar 25, 2:42 pm, Dave Peterson wrote: In xl2003: Tools|Options|View tab|Uncheck Outline Symbols On Mar 25, 3:10 pm, Paul wrote: Beautiful. Thanks! I don't suppose there is a way to turn off visibility of the outline symbols for row groups while still showing them for the column groups (and vice-versa)? -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Paul wrote:
When I have an outline consisting of grouped rows, there is an outline navigation panel along the left hand side. The user expands or collapses grouped rows using buttons on this navigation panel. Is there a way to hide this navigation panel? Thanks. On Mar 25, 2:42 pm, Dave Peterson wrote: In xl2003: Tools|Options|View tab|Uncheck Outline Symbols On Mar 25, 3:10 pm, Paul wrote: I don't suppose there is a way to turn off visibility of the outline symbols for row groups while still showing them for the column groups (and vice-versa)? On Mar 25, 3:44 pm, Dave Peterson wrote: Not that I see. Thanks anyway. Your solution above deals with most of the question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I hide the Help Panel? | Excel Discussion (Misc queries) | |||
Macro to show/hide detail in an outline | Excel Discussion (Misc queries) | |||
How do I hide the outline of a Forms Group Box? | Excel Discussion (Misc queries) | |||
How do you use the explode and collapse panel to hide rows? | Excel Worksheet Functions | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |