A drop down list is a list with predetermined options that expands when clicked to reveal the options available.

learn more… | top users | synonyms

11
votes
1answer
5k views

Setting a default value for a dynamic cascading validation list in Excel 2010

I have finally figured out how to build a dynamic cascading set of lists in Excel using Data Validation and the INDIRECT function. However, I'm running into a problem. I would like to set up my ...
9
votes
2answers
15k views

Can't use scrollbars of dropdowns (HTML select) in Chrome 32

After an update of Google Chrome to version 32 (the current stable version), the scroll bar on dropdowns (HTML elements) cannot be scrolled with dragging. It can only be scrolled by the mouse wheel. ...
4
votes
2answers
18k views

How do I copy the contents of a dropdown list to paste into a text document?

I'm looking for a tool that surely must exist somewhere... There's a dropdown list on a webpage with numerous values in it. I simply want to copy these values into the Windows clipboard and paste ...
3
votes
1answer
265 views

Replace data validation selection in Excel

I have list with the full name of the item and a list beside that with the short name of the item. I would like to create a drop down list whereby it will show the long name, but show only the short ...
3
votes
2answers
2k views

Firefox 11.0 Right-Click Dropdown Menu (and Menu Options at Window Top) Flickering - Potential Bug?

About a week ago my Windows 7 machine starting exhibiting odd Firefox behavior. When I right click on something the drop-down menu flickers and when the mouse is hovering over a field, I can't really ...
3
votes
2answers
3k views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
3
votes
2answers
3k views

midnight commander : how to invoke drop down on directory history list

I use mc 4.1.36 (C) ported to windows(I use Vista). I would love to be able to navigate through the list of directories that I've previously visited using the drop-down except that I don't know how to ...
2
votes
2answers
2k views

Select value from formula completion drop down list, by keyboard

How to select a value with the keyboard from a drop down list that is shown when composing a formula? I tried the following: Enter Space Alt-up or Alt-down as suggested here F4 (the default close-...
2
votes
2answers
6k views

Protecting a cell, but allowing the drop down list to work

I want to protect a cell that I have a drop down list in, but I still want the drop down list to work. When I try to protect it, the user is not able to use the drop down list to select other items ...
2
votes
3answers
2k views

How do I create a dropdown list for a column of constantly-changing values in Excel 2010?

I have an excel spreadsheet with a column for years, with a header: Years 1993 1993 1994 1994 1994 ... 2011 2011 There are duplicate values for the years, and additional rows will be added over ...
2
votes
2answers
2k views

How to add a program to a list with right click button?

When I right click on a file, a list of menu pops up. And, it has vim or emEditor for me to edit the file that I right clicked. I need to add emacs to that menu. How can I do that?
2
votes
2answers
42 views

Linked dropdown lists?

I would like to link 2 dropdown lists in Excel. Searching for solutions always resulted in cascading dropdown lists. What I want is two dropdown lists with the same options. When you change one, ...
2
votes
1answer
44 views

Can a drop down in Excel show long descriptions when clicked, but only a short code once selected?

I have created a drop down menu in Excel, but the options are long sentences. After someone selected one of the options I want a letter to appear instead of the entire option. How would that be ...
2
votes
1answer
70 views

Enforce style of named list items in Excel 2010

I have a named list with some values which have their own style (e.g. different colors): However when I apply that list as a data validation and select some values, the styling disappears: : How ...
2
votes
1answer
2k views

How can I copy a sheet with drop down boxes in Excel?

I have a weird situation. I have a workbook that has 6 drop down boxes within one of the sheets. Everytime I copy the sheet within the same workbook I get a box that pops up that says: A formula ...
2
votes
0answers
113 views

All windows dropdowns close instantly

Any combobox I try to open in the system closes itself instantly after having slided open. This makes it impossible to select something in a combobox. An example combobox is the one allowing you to ...
1
vote
2answers
740 views

How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)? Let's say the choices (drop-...
1
vote
1answer
1k views

Floating dropdown in Excel

Is it possible to click in a cell, a drop down appears, then whichever choice is made from the dropdown store that value. I made the dropdown and can place it on a cell but I have a lot of cell that ...
1
vote
1answer
21 views

How do I use the corresponding number to make the selection in a dropdown instead of using the mouse?

I looked at the information and it is just showing how to create the dropdown which I can do but I want to be able to type 1 and have it come up Very Poor, or 2 and have it come up with Poor, 3 ...
1
vote
1answer
65 views

Circle values that don't match any of the ones in a dropdown list

I created a dropdown list with values and assigned them to one of the columns in a table. When I changed a few, then changed the name of items in the list and removed some I accidentally did some key ...
1
vote
1answer
274 views

Creating a list based on a column

I need to create a dropdown list in sheet A based on the values in sheet B in column A. I clicked on the A column in B sheet and named it as Models. Then I clicked on the cell in sheet A where I ...
1
vote
1answer
5k views

Excel 2010 filter arrow not showing text values

I have an odd problem on a tracker spreadsheet I use. All the columns have a filter, but when you click on the filter arrow it doesn't show you a breakdown of all the text values for that column. All ...
1
vote
1answer
107 views

how to drop down the list of options in a drop down control (COMBO BOX) in a browser

I've known for a long time that F4 key drops down the list in a combo box(drop down) in windows applications. In I.E, the address box drops down if you press F4 anywhere in the page. This is NOT what ...
1
vote
1answer
192 views

Message with Drop-Down/Combobox?

Is there a way to include a drop-down or combo box in an Outlook message and have it display when you send the message to a recipient? Whenever I create the Combo Box control, it seems to be hidden ...
1
vote
2answers
2k views

microsoft edge drop-down menu not staying

in Microsoft edge on windows 10 when I tap on drop down menus it won't stop , like ebay when I tap on my ebay drop down , it shows it only for few second and goes away very quickly
1
vote
0answers
34 views

Partial populate dropdown list Word 2007

I need to build some reports defining what equiptment is Company Owned/Customer Owned. I need a dropdown list next to each Item. Since each report is for different customers. I would like the list to ...
1
vote
1answer
343 views

Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month. When an employee ...
1
vote
1answer
2k views

Embed Excel Chart with Drop-down control into powerpoint

I have an interactive Excel chart which runs on the basis of users selecting ranges using drop down menus via the form control and I want to move this into Powerpoint 2010 for presentation purposes. ...
1
vote
0answers
405 views

Multiple Selections from Dropdown in Word 2011 Form

Anyone know if there is a way to setup a Word form to allow the user to select multiple items from a dropdown list that are then displayed? For example, I need to setup a form to identify ...
1
vote
1answer
430 views

Edit drop-down desktop list [duplicate]

Possible Duplicate: Adding items to a files right click menu in windows explorer I have MS XP How do I edit or add items to the right-click drop-down list on my desktop?
0
votes
1answer
50 views

Create a drop down to specify multipliers in excel

I want to make an excel sheet where people can input how they spend their time. However, I want to give them different dimensions in which they can spend their time, for example "Hours / day" or "Days ...
0
votes
1answer
2k views

Excel 2013: Drop down list with date range?

I'm trying to create a simple drop-down list in one cell where I give a range like end of each month from 2010 till 2015 to be selectable. How do I do that please?
0
votes
3answers
655 views

Get rid of drop down cc-bcc-reply-to field when composing in Mail?

Is there any way to get rid of the drop down cc bcc reply-to etc. field menu in the compose new message window in Mail in Mac OS X Snow Leopard? The offending menu is the one immediately to the left ...
0
votes
1answer
38 views

Excel (.xlsx) - Drop-down lists/tables - Include specific values/text in drop-down list selection

Say I have a column, "Names", of single and multiple names (where two can occupy once cell), e.g. Names Anna Bruce Charlie Bruce / Charlie Anna / Bruce Upon creating a table I am given a drop-...
0
votes
1answer
107 views

Simple sum of dropbox values for scoring Excel 2013 worksheet

I would like to make a worksheet with dropboxes for scoring ingredients and summing the scores per ingredient. I already made the dropboxes with number 1-3(1=poor, 2=fair, and 3=good), but I would ...
0
votes
1answer
115 views

Dropdown + Autofill

I have a address list(name, street,city,telnumber) On another sheet I have a form, where I can choose the name from an dropdown list. Now I want to get street,city, telnumber for this name. Is this ...
0
votes
1answer
242 views

Drop downs dependent on each other [closed]

I have 2 lists of values: 1 Car 2 Dog 3 House 4 Hat 5 Boat Each of these is used to populate a drop down list. I am trying to allow the user to select from either 1-5 or Car-...
0
votes
1answer
122 views

Bible on Acrobat PDF with a static/top/center navigation bar with drop down menus for Book, chapter/verse

I need to create a regular static navigation bar in all pages of my PDF Bible, so people can easily go to book/chapter/verse number. Here is an example of what it should look like: http://www....
0
votes
1answer
297 views

Create drop-down list from values in one column that share the value of a cell in another column

I am having a hard time articulating my need. So, I don't know the key words to use that will find a solution. I have three columns: Project_Number Line_Item New_Line_Item A Project_Number can ...
0
votes
1answer
431 views

Excel 2010: VBA Convert incoming text into multi-select drop down list

I am regularly receiving a raw export file and I have written macros to format and manipulate it. I use Excel 2010 and I'm moderately comfy in VBA. One of the incoming columns has a list of names, ...
0
votes
1answer
2k views

How to select a value from drop down in a cell of MS Excel with keyboard?

Is there any way to select the value from drop down in excel by using only keyboard
0
votes
2answers
40 views

How do I create a sum based on a selection from a Dropdown box?

I am trying to work out a sum based on a selection from a Dropdown box. If the selection from the Dropdown is chosen and a figure is entered into a separate cell then an answer to a sum is then ...
0
votes
1answer
33 views

Excel help generating product codes

Good Day, I need help generating different product codes for a range of values. I want the product codes to be: SKU0000 to SKU9999 and I also need the subproducts for each of the main products ...
0
votes
0answers
25 views

Can Excel dropdown list be powered by SQL table (or view)?

I want to enter contractor acronyms into Excel cell. I want to achive: Validating contractor acronym with SQL table/view Autocomplete contractor acronym with SQL table/view while typing SQL table/...
0
votes
0answers
11 views

Make ComboBox Search List as User Types

I have been researching this for weeks now, and have not been able to locate what should be a simple solution to a simple problem. I have an Adobe Pro XI form with a ComboBox that has a very large ...
0
votes
1answer
39 views

How to populate a dynamic dropdown list based on a value and a table

I have a table as follows: Item Name Slot Bronze Dagger Main Hand Shortbow Off Hand Magic Staff Main Hand and so on. I want to have a drop down list somewhere ...
0
votes
0answers
14 views

Right click and menu bar drop down list not visible when clicked

It would be great if anyone could solve this for me. When I click on the Menu Tab or right click the list doesn't drop down. I can just about see a faint outline where the list is supposed to drop ...
0
votes
0answers
64 views

How to retrieve Word 2013 Content Control Drop Down List entry value

I have a Word 2013 document with 2 Content Control Drop Down List. Each of the list has Display Name in text and Value in number. Is it possible for me to create a field which conditionally display ...
0
votes
1answer
66 views

Code to Print List Loop to PDF

I have a spreadsheet that creates a graph and chart using a list selection. I have figured out the code to get the file to loop through the list and print each selection, however, I have not been able ...
0
votes
2answers
53 views

Add dropdown list to cell and include it's intial value

I want to add a dropdown list to cell A1 (which has a value of 2) The dropdown list has a number of items ("cats", "dogs", "cheese monkeys") This is easy. However, I want to included the initial ...