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

Giganews Newsgroups
Subject: Re: Data Validation - Allow List - In-cell Dropdown not showing up
Posted by:  Debra Dalgleish (d…@contexturesXSPAM.com)
Date: Sat, 15 May 2004

I think Dave meant,... "or remove the freeze panes"

You could use Window>Split instead

Dave Peterson wrote:
> Are you using windows|freeze panes?
>
> Is your cell with Data|validation above that line?
>
> If yes, move the cell or remove the data|validation.
>
> It's a bug in xl97, fixed in xl2k.
>
> Patrick Gibbons wrote:
>
>>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?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Replies

In response to

Re: Data Validation - Allow List - In-cell Dropdown not showing up posted by Dave Peterson on Sat, 15 May 2004