check box column

  • Thread starter Thread starter Candace
  • Start date Start date
C

Candace

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.
 
After formatting that column as "Wingdings 2" - typing an R [capital R] will
produce a check box.
Micky
 
Try, also, capital: P, Q, S, T, U, V
Micky


מיכ×ל (מיקי) ×בידן said:
After formatting that column as "Wingdings 2" - typing an R [capital R] will
produce a check box.
Micky


Candace said:
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?
Click to expand...
Click to expand...
 
Thanks Dave - this worked perfectly!

Dave Peterson said:
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.
Click to expand...
 
Back
Top