Thread: Data Validation - Allow List - In-cell Dropdown not showing up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
Patrick Gibbons Patrick Gibbons is offline
external usenet poster
  
Posts: 2
Default Data Validation - Allow List - In-cell Dropdown not showing up
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?



Reply With QuoteReply With Quote