|
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|
|
Data Validation - Allow List - In-cell Dropdown not showing up
My name Jose Jimenez.
(apologies to Bill Dana)
or....
mmmmm. XSPAM.
(apologies to Homer Simpson)
Debra Dalgleish wrote:
If you didn't use your real email address in the public newsgroups,
maybe you wouldn't get so much XSPAM!
Dave Peterson wrote:
Yes, I did. I was distracted by some XSPAM problems.
Debra Dalgleish wrote:
I think Dave meant,... "or remove the freeze panes"
You could use WindowSplit 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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
--
Dave Peterson
|