ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IS AN OPTION WHERE YOU CHECK A BOX AVAILABLE FOR A COLUMN? (https://www.excelbanter.com/excel-discussion-misc-queries/138572-option-where-you-check-box-available-column.html)

rebeccca

IS AN OPTION WHERE YOU CHECK A BOX AVAILABLE FOR A COLUMN?
 
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!

Teddy-B

IS AN OPTION WHERE YOU CHECK A BOX AVAILABLE FOR A COLUMN?
 
http://office.microsoft.com/en-us/ex...CL100570551033

Try the above page. I think it will help you!

"rebeccca" wrote:

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!


Gord Dibben

IS AN OPTION WHERE YOU CHECK A BOX AVAILABLE FOR A COLUMN?
 
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


On Wed, 11 Apr 2007 07:24:04 -0700, rebeccca
wrote:

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!



Dave Peterson

IS AN OPTION WHERE YOU CHECK A BOX AVAILABLE FOR A COLUMN?
 
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.

rebeccca wrote:

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!


--

Dave Peterson


All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com