LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
RagDyer
 
Posts: n/a
Default

Can't you click on the *numbers* and get the same expand and collapse
displays?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pspiel" wrote in message
...
The problem seems to be that the summary colum is the same for both the

group
and the sub-group. For example, the top group is columns I through M.

The
sub
group is columns J through M. Sometimes I want to hide I throuh L, and
sometimes I want to hide J through L and leave I showing. It won't let me

do
that. I don't know why.

"Dave Peterson" wrote:

Maybe you're not changing the range when you're applying the secondary

grouping.

Try it with a smaller set of columns.

pspiel wrote:

I have a set of columns in a group. Within that set I've made a

sub-group.
For some reason the +/- doesn't appear for the nested group, so I

can't hid
just those columns. For some reason I don't have this problem with

rows.
With rows if I make a group within a group the +/- boxes appear for

both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group

too?

--

Dave Peterson


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show data greater than 10 in pivot table Angus Excel Discussion (Misc queries) 6 September 15th 05 07:51 PM
formula to show 97.826 as 97.825 KevinBoyden Excel Discussion (Misc queries) 3 July 25th 05 03:30 PM
show text after formulas Shirley Excel Discussion (Misc queries) 3 June 30th 05 09:19 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
Show a date based on today DJ Dusty Excel Worksheet Functions 2 November 12th 04 03:20 AM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"