Drop down list indicator

[Falcon248]

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.

 

[מיכ×ל (מיקי) ×בידן]

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]

Excel 2007

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

 

[Gord Dibben]

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

 

[Falcon248]

It is the drop down arrow that I am having trouble with.

 

[מיכ×ל (מיקי) ×בידן]

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]

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.

 

[מיכ×ל (מיקי) ×בידן]

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]

Kudos. That was it. 2007 - Office Logo, Excel Options, Advanced, Under
Display Options for this worksheet, Show All.

Thanks again...