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

learn more… | top users | synonyms

-1
votes
1answer
31 views

Lock Drop Down Cells and Enable Use - Excel 2013

I would like a drop down list in a cell. I would like to lock the cell so it cannot be moved or altered but changes other than selecting from the drop down menu.
0
votes
1answer
36 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
2answers
39 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
32 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/...
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
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 ...
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
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 ...
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 ...
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 ...
1
vote
1answer
177 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 ...
0
votes
1answer
37 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
751 views

Update selected values on a dropdown list value change

I have 2 columns one is list and other is data validation with dropdown from that list, list one two three reference (the table where I use that list) three one one The formula for the list ...
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
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
65 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 ...
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
0
votes
1answer
172 views

Sort 'Drop Down List Content Control' form Alphabetically in WORD 2013

I'm using word 2013. I've created a drop down list using 'Drop-Down List Content Control' in the developer tab, but i can't seem to sort the drop down selections by Alphabetical order. Is this even ...
0
votes
1answer
2k views
3
votes
1answer
262 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 ...
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
2answers
738 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-...
0
votes
1answer
106 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 ...
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 ...
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 ...
0
votes
1answer
238 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-...
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
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. ...
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 ...
0
votes
1answer
144 views

Is it possible to have tab completion of drop-down lists in web pages in Firefox?

Does anyone know of a Firefox plugin that would enable tab-completion (or some other key sequence like Alt-L) of items in drop-down lists in web forms? e.g. ou<TAB>in<TAB>s<TAB> ...
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
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
3k views

Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet

I've been scouring the internet for this but can't seem to find a solution. Let's say I have 2 Sheets - "Items" and "Inventory". Inside "Items", I have 3 columns: Item Name Item Type Item Cost ...
0
votes
0answers
2k views

How to use a color coded drop down in Excel across multiple sheets?

I have seen a few examples on how to create a color coded drop down in an excel spreadsheet. An example of what to do can be seen here. http://stackoverflow.com/questions/12643522/excel-2007-drop-...
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 ...
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 ...
0
votes
1answer
691 views

Dropdown box arrow in a pdf appear on printouts

I have a .pdf with dropdown box form fields. The arrows on the dropdown boxes normally don't print, but on a new (Windows 8) computer they are suddenly printing. All other computers in the office ...
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. ...
0
votes
2answers
15k views

Checkbox in dropdown list

I have a table in excel where I can select multiple items from a dropdown list in one cell. Now, using my macro I have to pick all of the options separately, and they are added to a cell one by one. ...
0
votes
1answer
589 views

data validation exclude blank from list

My question is: How can I make a drop-down list that takes dynamic data (dates) and have "blank" cells, <""> because there function that prints date or "" . I've tried this video: https://www....
0
votes
1answer
2k views

How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...
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
0answers
50 views

Excel Drop Down List Errors

I was wondering if anyone is experiencing the same issue as I am. I have created a sheet with several tabs. The first column of each tab is referencing the same table in an overview tab. It works fine ...
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 ...
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 ...