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.