Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
-- Eva |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
Eva
ViewtoolbarsControl Tool Box or Forms select checkbox or option button, place it where you want, ok out. If this does not get you all you need post back and give a little more information as to what you are trying to accomplish. Mike Rogers "Eva" wrote: -- Eva |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
The problem with using a form is you can't sort by it -- so what I do is make
a drop down list with one item -- a square root symbol. It is a bit cheesy, but it works.... and that way in a sort you can sort checked and unchecked rows seperately. "Mike Rogers" wrote: Eva ViewtoolbarsControl Tool Box or Forms select checkbox or option button, place it where you want, ok out. If this does not get you all you need post back and give a little more information as to what you are trying to accomplish. Mike Rogers "Eva" wrote: -- Eva |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
I find this technique pretty easy...
Select the range 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. 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") Eva wrote: -- Eva -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
Dave
it will not work on excel 97 as when you go to font to choose wingdings it comes up with an error stating to use a built in number format But thanks as it works a treat in excel 2003 -- Eva "Dave Peterson" wrote: I find this technique pretty easy... Select the range 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. 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") Eva wrote: -- Eva -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
I'd try it again.
It's worked for me. Remember that you're holding the alt-key while typing 0252 on the numeric keypad. Eva wrote: Dave it will not work on excel 97 as when you go to font to choose wingdings it comes up with an error stating to use a built in number format But thanks as it works a treat in excel 2003 -- Eva "Dave Peterson" wrote: I find this technique pretty easy... Select the range 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. 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") Eva wrote: -- Eva -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter ticks in Excel 97 or check boxes
To be honest, I think it worked in xl97--but I don't have it to test.
I'd still try it again, though. Dave Peterson wrote: I'd try it again. It's worked for me. Remember that you're holding the alt-key while typing 0252 on the numeric keypad. Eva wrote: Dave it will not work on excel 97 as when you go to font to choose wingdings it comes up with an error stating to use a built in number format But thanks as it works a treat in excel 2003 -- Eva "Dave Peterson" wrote: I find this technique pretty easy... Select the range 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. 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") Eva wrote: -- Eva -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i set up check boxes in excel? | New Users to Excel | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) | |||
how to incert multiple check boxes in excel | Excel Worksheet Functions |