hiding/displaying rows
 

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

hiding/displaying rows
 

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.

hiding/displaying rows
 

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.

hiding/displaying rows
 

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


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 14:01:02 -0800, CMD wrote:

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.