In-Cell Drop Downs not visible

  • Thread starter Thread starter jrv
  • Start date Start date
J

jrv

I established a validation list for a cell and had the "In-cell" drop down
box checked. However, when I click in the cell, no drop down arrow appears.
I type values directly in the cell and the validation criteria is active (i.e
it doesn't let me type anything not on the list). I go to other cells in the
same file with the same results - no drop down arrow. I go to other excel
files and try the same thing and it works - I get a drop down arrow and list.
The file I am working with is not protected.

Any clues short of re-generating the offending file in a new workbook?

Regards,
JRV
 
Having "Hide all" selected under Tools, Option, View, Objects will cause
this.

--
Jim
|I established a validation list for a cell and had the "In-cell" drop down
| box checked. However, when I click in the cell, no drop down arrow
appears.
| I type values directly in the cell and the validation criteria is active
(i.e
| it doesn't let me type anything not on the list). I go to other cells in
the
| same file with the same results - no drop down arrow. I go to other excel
| files and try the same thing and it works - I get a drop down arrow and
list.
| The file I am working with is not protected.
|
| Any clues short of re-generating the offending file in a new workbook?
|
| Regards,
| JRV
 
Back
Top