Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
Can't seem to get the dropdown indicator to display, when I pass the mouse
over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
1) Are you sure that this was for a WorkSheet Data Validation Drop-Down Arrow ?
2) Could it be a "Comment" that you refer to ? 3) What version are we talking about ? Micky "Falcon248" wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
Excel 2007
"מיכאל (מיקי) אבידן" wrote: 1) Are you sure that this was for a WorkSheet Data Validation Drop-Down Arrow ? YES. 2) Could it be a "Comment" that you refer to ? NO 3) What version are we talking about ? Excel 2007 Micky "Falcon248" wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
If a DV dropdown you must select the cell.
Hovering or passing over will not show the arrow so don't know how it worked a few days ago. Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 09:39:01 -0800, Falcon248 wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
It is the drop down arrow that I am having trouble with.
"מיכאל (מיקי) אבידן" wrote: 1) Are you sure that this was for a WorkSheet Data Validation Drop-Down Arrow ? 2) Could it be a "Comment" that you refer to ? 3) What version are we talking about ? Micky "Falcon248" wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
As I don't know how this can be done.
Will be glad to learn. Until then I'll wait with you for a solution. Micky "Falcon248" wrote: It is the drop down arrow that I am having trouble with. "מיכאל (מיקי) אבידן" wrote: 1) Are you sure that this was for a WorkSheet Data Validation Drop-Down Arrow ? 2) Could it be a "Comment" that you refer to ? 3) What version are we talking about ? Micky "Falcon248" wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
I misspoke. When selecting the cell the dropdown arrow does not display. I
have an identical Data Validation on the other workbiooks and it works fine., Somehow it doesnt work on one workbook that was created from a template which is working fine. "Gord Dibben" wrote: If a DV dropdown you must select the cell. Hovering or passing over will not show the arrow so don't know how it worked a few days ago. Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 09:39:01 -0800, Falcon248 wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
Well, well, well....
If you will read again all you posts you'll realize that "Misspoke" is, in this case, an understatement ! As you preferred to keep the information about the version for yourself - I'll explain how this can be cured in "2003": Goto to menu 'Tools' 'Options' 'View' tab 'Objects' section check 'Show all'. Micky "Falcon248" wrote: I misspoke. When selecting the cell the dropdown arrow does not display. I have an identical Data Validation on the other workbiooks and it works fine., Somehow it doesnt work on one workbook that was created from a template which is working fine. "Gord Dibben" wrote: If a DV dropdown you must select the cell. Hovering or passing over will not show the arrow so don't know how it worked a few days ago. Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 09:39:01 -0800, Falcon248 wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. . |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list indicator
Kudos. That was it. 2007 - Office Logo, Excel Options, Advanced, Under
Display Options for this worksheet, Show All. Thanks again... "מיכאל (מיקי) אבידן" wrote: Well, well, well.... If you will read again all you posts you'll realize that "Misspoke" is, in this case, an understatement ! As you preferred to keep the information about the version for yourself - I'll explain how this can be cured in "2003": Goto to menu 'Tools' 'Options' 'View' tab 'Objects' section check 'Show all'. Micky "Falcon248" wrote: I misspoke. When selecting the cell the dropdown arrow does not display. I have an identical Data Validation on the other workbiooks and it works fine., Somehow it doesnt work on one workbook that was created from a template which is working fine. "Gord Dibben" wrote: If a DV dropdown you must select the cell. Hovering or passing over will not show the arrow so don't know how it worked a few days ago. Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 09:39:01 -0800, Falcon248 wrote: Can't seem to get the dropdown indicator to display, when I pass the mouse over the cell, for a drop down list located on another spreadsheet. This worked a few day ago. I've tried everything I can think of. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
how to display a drop down box indicator all the time | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | 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) |