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.

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.

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.