Data validation Drop Down Box not showing

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

hi...

have used data validation with a YES/NO list restriction
in it, the entires can be input, however I am not seeing
the drop down box which is usually associated with this

any ideas - am using MS Excel 2000 - 9.0.4402 SR-1 with
windows 2000

thanks
dave
 
Dave

You did not check "in-cell dropdown"?

Your DV cell is above the "freeze" line if you have Window>Freeze Panes
enabled?

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
And if it isn't the in-cell dropdown, try
tools|options|view
do you have objects being shown?

(Hide all hid the dropdown for me.)
 
Thanks Dave.

Another one of those "forgot about that" which seem to be increasing
exponentially.

Makes for some damn fine golf scores though<g>

Gord
 
I think it's associated with age--at least that's what Deb continues to say.

(just checking to see if she's lurking about.)
 
Back
Top