Grouping (Office 97)

Topic

New Reply

If I want to group together (from the Data/Group and Outline) for example the columns A-F and in a separate grouping the G-T, I can’t because the whole thing gets grouped together. Is there a way to group them separately though? I don’t want to have an empty column between the two groupings, and right now this seems to be the only way to get the effect I desire.

Thanks,
K.

Reply | Quote

Replies

Works for me, as long as I group them one at the time:

– select first set of columns, data, group and outline, group
– select second set of columns, data, group and outline, group

I can then expand both at will.

Or is that not what you meant?

Reply | Quote

That’s what I want as well, but as soon as I group the second set of columns, they will get grouped together with the first one, as it was all one single group.
Could you possibly post a small xls file to show the result of what you got?
Thx,
K.

Reply | Quote

Here it is…

Reply | Quote

Thanks, it works now.

K.

Reply | Quote