Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down box
I made a drop down box, how do i get the border to include the down arrow so
that is showing at all times even when the cell isnt highlighted? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down box
It sounds like you used Data|Validation to create this dropdown?
If yes, maybe you could add a shape to that cell (from the drawing toolbar). I just give those cells with data|validation a different fill color (I like light yellow). Jen wrote: I made a drop down box, how do i get the border to include the down arrow so that is showing at all times even when the cell isnt highlighted? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down box
Hey Dave!
I used the Data/Validation to create it... However, I want to show the arrow at all times rather than just the highlight.... quick reference... when you are on a website... you always know which answers have the drop down without clicking them first... is this possible? Also, I want to make a column with selector boxes that allow you to uncheck/check them depending on the status of the task... do you have any suggestions? Thank you! "Dave Peterson" wrote: It sounds like you used Data|Validation to create this dropdown? If yes, maybe you could add a shape to that cell (from the drawing toolbar). I just give those cells with data|validation a different fill color (I like light yellow). Jen wrote: I made a drop down box, how do i get the border to include the down arrow so that is showing at all times even when the cell isnt highlighted? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down box
#1. You could use a dropdown from the Forms toolbar or a combobox from the
Control toolbox toolbar. But you won't see the dropdown with data|Validation. #2. I'd just use a cell with a nice format: 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") ======= But you could use a checkbox from either the Forms toolbar or the control toolbox toolbar. Jen wrote: Hey Dave! I used the Data/Validation to create it... However, I want to show the arrow at all times rather than just the highlight.... quick reference... when you are on a website... you always know which answers have the drop down without clicking them first... is this possible? Also, I want to make a column with selector boxes that allow you to uncheck/check them depending on the status of the task... do you have any suggestions? Thank you! "Dave Peterson" wrote: It sounds like you used Data|Validation to create this dropdown? If yes, maybe you could add a shape to that cell (from the drawing toolbar). I just give those cells with data|validation a different fill color (I like light yellow). Jen wrote: I made a drop down box, how do i get the border to include the down arrow so that is showing at all times even when the cell isnt highlighted? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Box problem | New Users to Excel | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) |