Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box column
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box column
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box column
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box column
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box column
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a column in Excel as a check mark column? | Excel Discussion (Misc queries) | |||
How do I put a check box in each row of a column | Excel Discussion (Misc queries) | |||
how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
How do I Make a column in excel a check box column | Excel Discussion (Misc queries) | |||
how to set column check | Excel Worksheet Functions |