Excel Drop Down Lists

[biggles592]

I have a range of cells that I have formatted using Data Validation to have
their contents limited to selection from a drop Down list. However the down
arrow at the right hand side of each cell is missing or not displayed. What
could be wrong please?

 

[Gord Dibben]

The dropdown arrow is visible only when you select the cell.

Do you have "In-cell dropdown" selected?

Do you have Tools>Options>View>Objects set for "Show All"?


Gord Dibben MS Excel MVP

 

[FSt1]

hi
see this site...
http://www.contextures.com/xlDataVal08.html#ArrowsNotVisible

regards
FSt1

 

[biggles592]

Hi Gord,
Many thanks for responding to my enquiry. Yes I do have "In cell dropdown"
selected and I do appreiciate that the dropdown arrow is only visable when
the cell is selected. I can't however find Tools menu on any of the
following Tabs I have at the top of the screen; namely Home,Insert,Page
Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise
specifically where I can find this "Tools" menu please?. Additionally I did
try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003
format and running it in compatability mode. Whaddya Know! in >XLSX format
the dropdown arrows re-appear but this might be because I've not got
something set or checked in this version that is set or checked in the 97-03
version maybe???! Any ideas would greatly be appreiciated. Many thanks,
Biggles592

 

[Gord Dibben]

2007.............Button>Excel Options>Advanced>Display Options for workbook.

You will find Objects....All or Nothing.

Uncheck "nothing"


Gord

 

[biggles592]

Hi Gord,
Thank you for responding so quickly again. I've checked that all is selected
and it was but still running under compatability mode as an .xls file the
down arrows refuse to show. I've even cleared formats and data validation and
re-entered it to no avail. Most frustrating!

 

[Gord Dibben]

I think we have covered everything except workbook corruption.

But have a browse through Debra's site to see if anything applies to you.

http://www.contextures.on.ca/xlDataVal08.html#ArrowsNotVisible


Gord

 

[biggles592]

Agree we've covered everthing but nice to check with an expert! Remain
convinced it's a compatability issue as when I save the file as an .xlsx file
everything re-appears. So thats my answearthen. But many thanks for your kind
assistance.
Regards
Biggles592

 

[Gord Dibben]

Any chance you could send the file to me?

I'd like to test in 2003 and 2007.

Save as Excel 97-2003 format.

Send to gorddibbATshawDOTca change the obvious.


Gord

 

[Lil Red Riding In The Hood]

Any chance you could send the file to me?

I'd like to test in 2003 and 2007.

Save as Excel 97-2003 format.

Send to gorddibbATshawDOTca change the obvious.


Gord

He may be confused by something he saw elsewhere.

If one creates a combo-box with a scroll bar edge, it remains at all
times.