See if this helps:

http://contextures.com/xlDataVal08.h...rowsNotVisible

--
Biff
Microsoft Excel MVP


"Jey" wrote in message
...
Did you ever get this resolved? I'm having the same problem in Excel 2007.
The 'In-cell dropdown' option is checked, and 'For objects-show all' is
checked (in Office Button-Excel options-Advanced-Display options for
this
workbook). I can see the dropdown lists on one worksheet but not on
another,
so it must be something cell or worksheet specific, rather than a setting
for
the whole workbook. (?)

Jey

"T. Valko" wrote:

Check this setting:

ToolsOptionsView tabObjectsShow All

--
Biff
Microsoft Excel MVP


"Angela" wrote in message
...
Yes it is. All seems to be ok, however I'm just not seeing the drop
down
box.

"akphidelt" wrote:

Do you have the In-Cell Dropdown checkbox, checked?

"Angela" wrote:

The list was created using Validation, however when I click on the
cell
where
the drop down list should appear, nothing. It doesn't give the drop
down
list.

"FSt1" wrote:

hi
is it data validation? you can't see it untill you click in the
cell.

regards
FSt1

"Angela" wrote:

I can't see the drop down list that I have created. Any ideas
why?