Excel Drop Down Lists

  • Thread starter Thread starter biggles592
  • Start date Start date
B

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?
 
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
 
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
 
2007.............Button>Excel Options>Advanced>Display Options for workbook.

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

Uncheck "nothing"


Gord
 
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!
 
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
 
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
 
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
Click to expand...


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.
 
Back
Top