| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with drop down list
when I put my mouse over the cell which has the drop down list, the arrow
does not show. How can I get the arrow for the list to show when I put the mouse on it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with drop down list
Click the cell? or otherwise select it (as with arrow keys)?
Excel doesn't know that while you are hovering over the cell you want to see the arrow. However, it does know you're hovering over it - and if you INSERT a COMMENT, when you hover over it, the comment will display. So you could insert a comment to clue the user that there's a list there, perhaps something like: Click Here To Select From List "TMBS P.M." wrote: when I put my mouse over the cell which has the drop down list, the arrow does not show. How can I get the arrow for the list to show when I put the mouse on it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with drop down list
The arrow does not show even if I click on the cell.
"JLatham" wrote: Click the cell? or otherwise select it (as with arrow keys)? Excel doesn't know that while you are hovering over the cell you want to see the arrow. However, it does know you're hovering over it - and if you INSERT a COMMENT, when you hover over it, the comment will display. So you could insert a comment to clue the user that there's a list there, perhaps something like: Click Here To Select From List "TMBS P.M." wrote: when I put my mouse over the cell which has the drop down list, the arrow does not show. How can I get the arrow for the list to show when I put the mouse on it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with drop down list
Makes me think you don't really have data validation set up in that cell even
though you think you do. Go through the steps for setting up Data Validation for a cell carefully and see if it doesn't work for you. If that gives you no relief, you can send the workbook to me at (remove spaces) HelpFrom @ jlathamsite.com and I'll take a look at it and see if I can help more. "TMBS P.M." wrote: The arrow does not show even if I click on the cell. "JLatham" wrote: Click the cell? or otherwise select it (as with arrow keys)? Excel doesn't know that while you are hovering over the cell you want to see the arrow. However, it does know you're hovering over it - and if you INSERT a COMMENT, when you hover over it, the comment will display. So you could insert a comment to clue the user that there's a list there, perhaps something like: Click Here To Select From List "TMBS P.M." wrote: when I put my mouse over the cell which has the drop down list, the arrow does not show. How can I get the arrow for the list to show when I put the mouse on it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
