Working with Drop Down List
I created 2 drop down list. They have both been working for a month. Today they are not available. I checked Data Validation, redid the Create process. Still no drop down list in programed cells. Could I have turned them 'Off' unintentionally?
I have a very simple workbook. Excel 2010
Sheet 2 has the cells A1 to A4 filled (this will be my list content)
Sheet 1, I create the list through Data Validation. It works. I save my workbook and the little arrow goes away to select the drop down, I must right click then select Pick from drop down list.
How can I get the click selection to stay active?
I have a workbook with a couple of drop down lists. They are done with data validation of a named range.
Data validation settings are Allow: list. Source: =Client. Which is a valid named range when I look it up. Ignore blank and In-cell drop down are both checked.
There are actually 2 different data validation settings in 2 different columns based on 2 different named ranges and neither are working. It still validates the data, as it doesn't let me enter stuff that isn't on the list, but the drop down boxes are just not showing up.
It was working fine until a couple of days ago. I did have some frozen panes which I read can be a problem. I removed all of those, saved, closed, reopened but still not working.
Is there any way in Excel to create a drop down list which contains colours?
For example to show RAG status (i.e. Red Amber Green).
At the moment I can only show text in the drop down list.
Would anyone know a way of working around this?
I'm working on a spreadsheet made by someone else. When I click on a cell on my PC, I get a drop down menu with 8 choices and up/down arrows which allow me to scroll to see other drop down choices.
When I open the same document on a MAC, the entire drop down list opens up so I can easily choose from the entire list. This is MUCH easier for me.
How am I able to view the entire drop down list on my PC?
Related Applications & Scripts
This is a jQuery plug-in, which helps to make beautiful sliding drop lists available in 6 color schemes.
Simple nav with drop down menus. Easy to use with dynamic links changeable in the script. Set up to target a URL or frame label on press.
The wizard generates the code necessary for your own simple drop down menu. Each option on your menu will link to a selected page. Options are also given for you to select the colors and fonts.
This is a very clean and simple HTML5 friendly drop navigation script. It uses either the Prototype library or the jQuery library and is written primarily using HTML5 and CSS3 markup. The drop menu script can be configured to show any type of content. Examples are included as well as detailed commenting to help you set it up.
Adobe Dreamweaver MX or later