Is there a clean easy way to get checkbox functionality on an Excel
spreadsheet? I need to add a column to my spreadsheet that has a checkbox (or
something comparable) in each cell of that column. However, I looked at
adding checkboxes using either a form control or an activex control and both
seem to sit on top of the spreadsheet, rather than being associated with a
cell itself. Any ideas?

I'd use something simple--like an X.

But if you want something prettier:

(saved from a previous post)

Select the range that would have held the checkboxes.
Format|cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings (make it as large as you want)

Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
mark.

Hit the delete key on the keyboard to clear the cell.

If you have to use that "checkmark" in later formulas:
=if(a1="","no checkmark","Yes checkmark")
or
=counta(a1:a10)
to get the number of "checked" cells in A1:A10

Or you can filter by blanks and non-blanks.

Candace wrote:
>
> Is there a clean easy way to get checkbox functionality on an Excel
> spreadsheet? I need to add a column to my spreadsheet that has a checkbox (or
> something comparable) in each cell of that column. However, I looked at
> adding checkboxes using either a form control or an activex control and both
> seem to sit on top of the spreadsheet, rather than being associated with a
> cell itself. Any ideas?

--

Dave Peterson

After formatting that column as "Wingdings 2" - typing an R [capital R] will
produce a check box.
Micky


"Candace" wrote:

> Is there a clean easy way to get checkbox functionality on an Excel
> spreadsheet? I need to add a column to my spreadsheet that has a checkbox (or
> something comparable) in each cell of that column. However, I looked at
> adding checkboxes using either a form control or an activex control and both
> seem to sit on top of the spreadsheet, rather than being associated with a
> cell itself. Any ideas?

Try, also, capital: P, Q, S, T, U, V
Micky


"מיכ�ל (מיקי) �בידן" wrote:

> After formatting that column as "Wingdings 2" - typing an R [capital R] will
> produce a check box.
> Micky
>
>
> "Candace" wrote:
>
> > Is there a clean easy way to get checkbox functionality on an Excel
> > spreadsheet? I need to add a column to my spreadsheet that has a checkbox (or
> > something comparable) in each cell of that column. However, I looked at
> > adding checkboxes using either a form control or an activex control and both
> > seem to sit on top of the spreadsheet, rather than being associated with a
> > cell itself. Any ideas?

Thanks Dave - this worked perfectly!

"Dave Peterson" wrote:

> I'd use something simple--like an X.
>
> But if you want something prettier:
>
> (saved from a previous post)
>
> Select the range that would have held the checkboxes.
> Format|cells|number tab|custom category
> In the "type:" box, put this:
> alt-0252;alt-0252;alt-0252;alt-0252
>
> But hit and hold the alt key while you're typing the 0252 from the numeric
> keypad.
>
> It should look something like this when you're done.
> ü;ü;ü;ü
> (umlaut over the lower case u separated by semicolons)
>
> And format that range of cells as Wingdings (make it as large as you want)
>
> Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
> mark.
>
> Hit the delete key on the keyboard to clear the cell.
>
> If you have to use that "checkmark" in later formulas:
> =if(a1="","no checkmark","Yes checkmark")
> or
> =counta(a1:a10)
> to get the number of "checked" cells in A1:A10
>
> Or you can filter by blanks and non-blanks.
>
> Candace wrote:
> >
> > Is there a clean easy way to get checkbox functionality on an Excel
> > spreadsheet? I need to add a column to my spreadsheet that has a checkbox (or
> > something comparable) in each cell of that column. However, I looked at
> > adding checkboxes using either a form control or an activex control and both
> > seem to sit on top of the spreadsheet, rather than being associated with a
> > cell itself. Any ideas?
>
> --
>
> Dave Peterson
> .
>