Data Validation - Allow List - In-cell Dropdown not showing up

Giganews Newsgroups
Subject: Data Validation - Allow List - In-cell Dropdown not showing up
Posted by:  Patrick Gibbons (fnkler…@hotmail.com)
Date: Sat, 15 May 2004

This is in a MS Office 97 Excel Workbook, although I have selected data
validation for a cell the in-cell dropdown is not showing up.  Of course
some silly person would tell me that I don't have the In-cell Dropdown
checkbox selected . . . got it smart guy.  It is still not working.

I will give you the current setup:

Cell L4 has the current data validation:
    Allow: List
    Source: =$B$54:$B$65
    Ignore blank - selected
    In-cell Dropdown - selected

Cells B54:B65
    January
    February
    March  . . . etc.

Anyone have any ideas?

Replies