IS AN OPTION WHERE YOU CHECK A BOX AVAILABLE FOR A COLUMN?

R

rebeccca

I have a large database in excel. I would just like in option in one column
where if the subject applies, you can just check a box. Is this possible and
if so, how do I do it? Thanks!
 
G

Gord Dibben

Most likely can be done but from your description it is difficult to give a "how
to" answer.

How will Excel know if "the subject applies"?

What criteria determine this and what type of option is required?

A better description of your data layout would help.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

I find that using another column and putting an X (or any non-blank character)
in that cell is easiest.

Then I can apply data|filter|autofilter and see all the non-blanks or blanks.
 
Top