Thats a great suggestion...thanks.

"MyVeryOwnSelf" wrote:

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.