Labeling Collapsed Columns

T

trickyfingers28

I'm using the grouping function in Excel to collapse several sets of adjacent
"detail" columns. I would like to place a label next to the "+" sign to
indicate what kind of details will show up if the column is expanded. Could
some one advise how I might do this. I tried the hyperlink approach but it
didn't "unhide" the cells which I had hidden.
 
R

RagDyeR

With this feature, you *must* have a summary (total) column separating each
group, which would remain displayed under the outline symbols (+, -).

You can key in "header" information in the first row of this summary column,
and then "Freeze Panes" on that first row to keep those labels always
visible, therefore labeling the group *UNDER* the outline symbols.

By default, this summary column is to the right of the grouped columns.

This can be changed, to place the summary column to the left of the group
by:

<Data> <Group & Outline> <Settings>
And choose the location in that window.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message I'm using the grouping function in Excel to collapse several sets of
adjacent
"detail" columns. I would like to place a label next to the "+" sign to
indicate what kind of details will show up if the column is expanded. Could
some one advise how I might do this. I tried the hyperlink approach but it
didn't "unhide" the cells which I had hidden.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top