A
Angela
I can't see the drop down list that I have created. Any ideas why?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi
is it data validation? you can't see it untill you click in the cell.
regards
FSt1
is it data validation? you can't see it untill you click in the cell.
regards
FSt1
A
Angela
The list was created using Validation, however when I click on the cell where
the drop down list should appear, nothing. It doesn't give the drop down
list.
the drop down list should appear, nothing. It doesn't give the drop down
list.
A
akphidelt
Do you have the In-Cell Dropdown checkbox, checked?
A
Angela
Yes it is. All seems to be ok, however I'm just not seeing the drop down box.
T
T. Valko
Check this setting:
Tools>Options>View tab>Objects>Show All
Tools>Options>View tab>Objects>Show All
J
Jey
Did you ever get this resolved? I'm having the same problem in Excel 2007.
The 'In-cell dropdown' option is checked, and 'For objects->show all' is
checked (in Office Button->Excel options->Advanced->Display options for this
workbook). I can see the dropdown lists on one worksheet but not on another,
so it must be something cell or worksheet specific, rather than a setting for
the whole workbook. (?)
Jey
The 'In-cell dropdown' option is checked, and 'For objects->show all' is
checked (in Office Button->Excel options->Advanced->Display options for this
workbook). I can see the dropdown lists on one worksheet but not on another,
so it must be something cell or worksheet specific, rather than a setting for
the whole workbook. (?)
Jey
T
T. Valko
J
Jey
Hi,
Thanks for the link. It wasn't any of those, but on a whim I just copied
everything to a new worksheet, and now it all works fine! I tried copying
back to the original worksheet, and still no list. Very odd, but I'm not
going to loose any sleep trying to figure it out... its all good now.
Jey
Thanks for the link. It wasn't any of those, but on a whim I just copied
everything to a new worksheet, and now it all works fine! I tried copying
back to the original worksheet, and still no list. Very odd, but I'm not
going to loose any sleep trying to figure it out... its all good now.
Jey