Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a group or outline
When a range of cells are grouped/outlined and you can see the +/- symbols,
is it possible to name this group so that the name is visible when the group is collapsed? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a group or outline
Maybe you could give it a custom view name.
In xl2003, it's under view|Custom views Edwina wrote: When a range of cells are grouped/outlined and you can see the +/- symbols, is it possible to name this group so that the name is visible when the group is collapsed? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a group or outline
Thanks Dave but that didn't work. I wanted the group name to be visible down
the side bar. Maybe it can't be done? "Dave Peterson" wrote: Maybe you could give it a custom view name. In xl2003, it's under view|Custom views Edwina wrote: When a range of cells are grouped/outlined and you can see the +/- symbols, is it possible to name this group so that the name is visible when the group is collapsed? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a group or outline
I don't think you can do that.
You could add some buttons from the forms toolbar. And these buttons could have macros assigned to them that hide/show the stuff you want. But it wouldn't be the same. Edwina wrote: Thanks Dave but that didn't work. I wanted the group name to be visible down the side bar. Maybe it can't be done? "Dave Peterson" wrote: Maybe you could give it a custom view name. In xl2003, it's under view|Custom views Edwina wrote: When a range of cells are grouped/outlined and you can see the +/- symbols, is it possible to name this group so that the name is visible when the group is collapsed? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a group or outline
Thanks Dave but that doesn't give me what I'm looking for either. i think
this is one time I'm looking for the impossible. Thanks for your help anyway. "Dave Peterson" wrote: I don't think you can do that. You could add some buttons from the forms toolbar. And these buttons could have macros assigned to them that hide/show the stuff you want. But it wouldn't be the same. Edwina wrote: Thanks Dave but that didn't work. I wanted the group name to be visible down the side bar. Maybe it can't be done? "Dave Peterson" wrote: Maybe you could give it a custom view name. In xl2003, it's under view|Custom views Edwina wrote: When a range of cells are grouped/outlined and you can see the +/- symbols, is it possible to name this group so that the name is visible when the group is collapsed? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
Group and Outline tool | Excel Discussion (Misc queries) | |||
Group and Outline | New Users to Excel | |||
Group and Outline | Excel Discussion (Misc queries) | |||
Outline / Group buttons | Excel Worksheet Functions |