I've added some ActiveX form control CommandButton on my sheet.
When I group the rows that contains the CommandButton, and I collapse the "+" button, the rows are all hidden except for the CommandButton.
It was all "pushed" below where the row the grouping collapse.
Does anyone have any idea to solve this issue? Thanks for your help!
When my user clicks a Group by button in Excel (+)(-), I want that event to kick off a macro that will hide columns D and E.
The idea is that when the user views data at different levels of aggregation, the spreadsheet will 'de-clutter' itself by hiding columns that the user doesnt need to see.
There is no obvious Excel event that responds to Group By. Can a Class Module achieve this? If so, can someone give me a 30 second overview? Any other ideas?
thanks dudes
I have a sheet that has drop downs in it. I am grouping rows together under headers. The drop downs do not hide when I click the - button to collapse the group.
Greetings,
I want to group columns so that I can hide/reveal them for presentation purposes, not summary/calculation purposes. I think Excel wants to group for summary/calculation purposes.
When I select columns A-D and group them, it seems that the grouping works fine. I can hide/reveal via the controls [+] [-]. When I select E-H and group that, Excel wants to concatenate the groupings into 1 large group, A-H. This happens for any contiguous grouping. I'm thinking this is because Excel really want to group with a summary column to the right so it assumes everything needs to be grouped together, though I 'm not sure that is the case. If i turn off summary
Is there any way to get Excel to handle column groupings such that I can group columns independently even though they are juxtaposed?
Thanks,
Mark
This one is killing me.
Lets say that columns A:D are sales figures for Jan, Feb, Mar, and in total for Adam.
Columns E:H are sales figures for Jan, Feb, Mar, and in total for Brian.
Column I:L are the total sales figures for Jan, Feb, Mar, and in total. IE column I = A+E
So, I goup A:C so that it collapses to Adam's total. Then I group E:G so that it collapses to Brian's total. Next I group I:K so they collapse to the grand total. The problem is that when I then group A:K to collapse all detail down to just to the grand total, my third set of groupings is eliminated.
How do I make this higher level grouping while maintaining my I:K grouping?
Thanks,
~Nick~
Hi I have the data In columns as shown below Please help me with a code to group columns
Quarterly and Annually
30-Sep-06
30-Sep-06
31-Dec-06
31-Dec-06
31-Dec-06
31-Mar-07
31-Mar-07
31-Mar-07
30-Jun-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-08
Ryan
Using Excel 2000 in a Win 2000 O/S, is is possible to group columns
individually? Currently if I group, for example, column C, so that I can
collapse it, when I group column D, it gets joined to column C's group. I
want to be able to collapse and expand columsn separately.
--
LPS
I have a spreadsheet where the columns of data are in logical groups.
For example,
I have 5 columns of data for the month of February, followed by the same 5
columns but for March etc.
What I want to do is than when the user scrolls right or left the whole of
one month moves and not part of it.
is there some way to group the columns so that they will scroll as a unit?
Jonathan Blitz
AnyKey Limited
Israel
I am using Excel 2007. I need to create several groups of columns in a spreadsheet. It allows me to group columns A, B & C. When I try to create a separate group with columns D, E & F, is adds it to the first group with A, B & C. How do I create separate groups of columns on the same spreadsheet?
