hiding/displaying rows

[Guest]

Hi. I am creating a worksheet and I would like to be able to hide certain
rows with a single click. I don't think the group/ungroup function will work
for me. Here is what I am trying to do:

Lets say I have the following rows:

Scenario A - Item #1
Scenario B - Item #1
Scenario C - Item #1
Scenario A - Item #2
Scenario B - Item #2
Scenario C - Item #2
Scenario A - Item #3
Scenario B - Item #3
Scenario C - Item #3

Is there a way to do this such that I can click a button and it will hide
all of the Scenario B&C items so that I just see Scenario A? I would like to
be able to choose the scenario and hide the other 2. Thanks in advance.
Chris

 

[MyVeryOwnSelf]

Hi. I am creating a worksheet and I would like to be able to hide

certain rows with a single click. I don't think the group/ungroup
function will work for me. Here is what I am trying to do:

Lets say I have the following rows:

Scenario A - Item #1
Scenario B - Item #1
Scenario C - Item #1
Scenario A - Item #2
Scenario B - Item #2
Scenario C - Item #2
Scenario A - Item #3
Scenario B - Item #3
Scenario C - Item #3

Is there a way to do this such that I can click a button and it will
hide all of the Scenario B&C items so that I just see Scenario A? I
would like to be able to choose the scenario and hide the other 2.
Thanks in advance. Chris

One way is to select the column that identifies the scenario and use
Data > Filter > AutoFilter

This'll provide a pull-down to choose one of the scenarios or "all."

Not exactly a "button" like you asked for, but it's easy to do.

 

[Guest]

Thats a great suggestion...thanks.

One way is to select the column that identifies the scenario and use
Data > Filter > AutoFilter

This'll provide a pull-down to choose one of the scenarios or "all."

Not exactly a "button" like you asked for, but it's easy to do.

 

[Gord Dibben]

After using the autofilter you can save custom views of each set and just pick a
view from View>Custom Views.


Gord Dibben MS Excel MVP