Check Box & Filter or not
 

I am not sure if the use of the check box is correct. I am new to forms in
Excel 2007and don't even know how to add multiple items to be checked or if
that is possible.

My scenario is this:
I want to be able to have in cell C1 the ability to select from 5 options
(able to select 1 or more of those). I would like the same options to occur
down the column - C2, C3, etc. After the user selects those options for each
row, I need to be able to filter based on those selections. Ex: show all rows
where Option 2 & 3 were selected.

I need to be able to show all or just the filtered selection in print
version, so I don't want to have to create a new row for each option and
create a much larger print version of the info.

Any help is appreciated. Thanks.

Check Box & Filter or not
 

Sounds like Data Validation with a filter would be the way to go. (On the
Data Tab - Data Tools section)

You can enter your options as a list and paste the validation all the way
down.

With the filter on (Data Tab - Sort & Filter), you can hide all but the
desired rows. If you data is a continuous block simply clicking the filter
button will probably suffice. If you have skipped rows or columns, you may
need to select your data and headers first.
--
If this helps, please remember to click yes.


"Carl W." wrote:

I am not sure if the use of the check box is correct. I am new to forms in
Excel 2007and don't even know how to add multiple items to be checked or if
that is possible.

My scenario is this:
I want to be able to have in cell C1 the ability to select from 5 options
(able to select 1 or more of those). I would like the same options to occur
down the column - C2, C3, etc. After the user selects those options for each
row, I need to be able to filter based on those selections. Ex: show all rows
where Option 2 & 3 were selected.

I need to be able to show all or just the filtered selection in print
version, so I don't want to have to create a new row for each option and
create a much larger print version of the info.

Any help is appreciated. Thanks.

Check Box & Filter or not
 

Thanks Paul, that was helpful, but the list only allows me to have one
selection per row. Is there a way to allow more then one selection per cell?

"Paul C" wrote:

Sounds like Data Validation with a filter would be the way to go. (On the
Data Tab - Data Tools section)

You can enter your options as a list and paste the validation all the way
down.

With the filter on (Data Tab - Sort & Filter), you can hide all but the
desired rows. If you data is a continuous block simply clicking the filter
button will probably suffice. If you have skipped rows or columns, you may
need to select your data and headers first.
--
If this helps, please remember to click yes.


"Carl W." wrote:

I am not sure if the use of the check box is correct. I am new to forms in
Excel 2007and don't even know how to add multiple items to be checked or if
that is possible.

My scenario is this:
I want to be able to have in cell C1 the ability to select from 5 options
(able to select 1 or more of those). I would like the same options to occur
down the column - C2, C3, etc. After the user selects those options for each
row, I need to be able to filter based on those selections. Ex: show all rows
where Option 2 & 3 were selected.

I need to be able to show all or just the filtered selection in print
version, so I don't want to have to create a new row for each option and
create a much larger print version of the info.

Any help is appreciated. Thanks.