Excel Drop Down Lists


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?
 
Ad

Advertisements

G

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
 
B

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
 
G

Gord Dibben

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

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

Uncheck "nothing"


Gord
 
B

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!
 
Ad

Advertisements

B

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
 
G

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
 
Ad

Advertisements

L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top