ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Naming a group or outline (https://www.excelbanter.com/excel-discussion-misc-queries/210420-naming-group-outline.html)

Edwina

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?

Dave Peterson

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

Edwina

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


Dave Peterson

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

Edwina

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



All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com