Questions tagged [dropdownlist]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

How to filter dropdown list based on value in another dropdown?

I have two separate dropdowns one category and another is type. What I want to do is filter the type column based on what the category has. So for example when categories 'A' or 'B' are chosen 'KD' ...
0
votes
1answer
36 views

Excel Cell Currency Picker

I want to show the currency symbol (as format not text or concat prefix) in a cell which is set as a defaulted "AUD" currency so it'll look like "AUD 1,450,000.00" but have that ...
2
votes
1answer
70 views

Excel cannot define a List in Data Validation from an existing Table Name and Column

In cell O2 below, I want to propose a drop down list box of values which are defined in the column Group of the table Table2 (this table is located in the columns L and M), but I get a generic error ...
0
votes
2answers
24 views

drop down list in excel2016

I have created drop down list as per attached image. but the problem is I have long list of same item, the drop down list shows the same item as much as my data contain. is there any solution? As seen ...
0
votes
0answers
21 views

Excel drop down disappeares after deleting rows

I have created a drop down using data validation list. The issue is that when I delete rows the drop down in my cells also gets deleted. Is there any way tor retain the drop down ? I delete rows ...
1
vote
1answer
79 views

Create drop-down list based on two other criteria

I have a range of data relating to buildings. The fields are building type, entry into the building, and size of the building. I have created drop-down lists for the building and entry type. I now ...
0
votes
1answer
24 views

Limit in excel data validation source code

I have an excel file with two sheets. The second sheet (Report) contains data validation cells based on the first sheet (Data). From the second sheet, the drop-down list that displays in the Select ...
1
vote
0answers
45 views

Users Bypassing Workbook Protections - What Did I overlook?

I created a Excel 2016 workbook that was to be sent to multiple department heads to then be distributed to their personnel to solicit input on a topic. Some of the columns were free response; some ...
0
votes
1answer
60 views

Dropdown list which depends on active/inactive status of a neighboring cell (Excel 2010)

I'm using Excel 2010 I have a spreadsheet to track my time charging. I have all of the charge numbers in Table1 and I use a drop-down list in another sheet to select the charge code to use for each ...
0
votes
0answers
22 views

stop flyout menu expation when sliding mouse over menu on webpages

I am using Firefox, Home Depot is the worst offender on this topic, but there are others, How do I set Firefox (setting, addon, extension, etc,,,) to not expand menu flyout when hovering over menu ...
1
vote
1answer
24 views

Creating a drop-down list that skips blank reference cells

I would like to create a drop-down list from another worksheet in the same file. The other worksheet has a number of items listed, and some criteria that may exclude the item from being useful in my ...
-1
votes
0answers
11 views

Drop-down list with Jpeg in Word

I'm looking how to do a drop- down list with images. The same way we do a drop-down list in Excel. I want to do a drop down list to change bullet colors from red, to blue , to green ,Etc. Any help ...
0
votes
0answers
12 views

MS Office 2016 Excel Auto filling a drop down menu in one cell based on another cell drop down option selection

This looks simple, but couldn't figure out how to do it. I have two drop down cells A1 and A2, both have same drop down options. A1 options are "Yes", "No". A2 options are "Yes", "No" Question is: ...
0
votes
0answers
14 views

Excel Dropdown List from Range + One Static Value

Id like to create a DropDown list from a Named Range containing all months in the year, but also id like to add a static value at the beginning of the list called "All" im wondering if that's possible!...
0
votes
1answer
707 views

Disable certain drop down list selections based on another cell

Let's say that in column A, users enter in different numbers. In column B, there are options of Y or N. If column A has a cell with the value of zero, it should disable the "N" option in column B. How ...
0
votes
0answers
18 views

Excel - Drop down list that allows non-listed values

I'm looking for a way to have a drop-down list based on existing data BUT that allows me to enter values that are not included. Let me picture the situation: I have an evaluation form where we enter ...
1
vote
2answers
704 views

Excel - Colouring items in dropdown list

I created a dropdown list on excel but I have lots of items in it. I want to categorize the items in that list and make the similar ones appear in the same colour. All I could find so far was how to ...
0
votes
2answers
58 views

Microsoft Excel 2016 - Need to auto populate cells based on conditional drop down lists

Good afternoon. I am a high school Strength and Conditioning coach and want to provide my athletes with progress reports based on data I keep in a master data sheet. This spread sheet has over 5000 ...
0
votes
0answers
30 views

Drop down menu but return other values in word

I want to make a dropdown menu in Word but when I choose something, for example "fruit" it should return as "apple". I'm using this to create a form some kind of form for my ...
0
votes
0answers
24 views

Varying Chart Range Based on Drop Down Lists

I'm hoping to get some help with automatically updating the chart range in Excel based on what's selected in a drop down list. I have 3 selections for my drop down list: All, Alberta and Saskatchewan....
0
votes
2answers
868 views

Change out column of data using drop down

I'm looking to change out a column of data in my excel spreadsheet with 8760 data points without copy and paste. I'd like to use a drop down menu to select various data set columns in other tabs of ...
0
votes
0answers
61 views

Excel: dropdown list determines how many rows are in a table

I am trying to populate rows based on user selection from a dropdown box. When A3 is selected I would like to have column B populate (inserting the same number of rows + (the total row) as items in ...
0
votes
1answer
71 views

Choosing a specific drop-down choice that places a cursor in, or highlights, another cell for data entry

In Excel, 2016, I have created a table that includes drop-down selections in some cells. Example table I would like to find a formula that prompts another cell to be highlighted, framed, or have a ...
0
votes
1answer
96 views

Value retrieval from the multiple selection dropdown in Excel

I am trying to make calculation from my dropdown menu. I have following dropdown in sheet 1 in my Excel. ## Category ## ### AAA ### ### BBB ### ### CCC ### ### DDD ### In sheet 2, I have ...
1
vote
0answers
24 views

Is there a quicker way to open a single file in different programs?

This question is asked because I use .Tif files, and need to alternately open them in a photo viewer (to quickly see files) and an image editor (to work on them). Its not an urgent problem, but I ...
0
votes
1answer
371 views

Data validation in Excel based on value matrix

I'm really struggeling to solve the following task. I have a data matrix where vehicles and features are matched. Now I want to use this as source for Excels input validation feature in a second ...
0
votes
0answers
148 views

Excel: Filter by Substrings

I have a list of movies in an Excel table. In one column, titled "Genre", the movie genre is shown. A movie can have one, or several genres, separated by commata (and sorted alphabetically): Now, ...
1
vote
1answer
88 views

Conditional defalt on data validation list

EDIT No. 2 *Ok, my previous articulations of my problem were, as pointed out, pretty rubbish. This edit, rephrases the question in a more straightforward manner, summarises the context and provides ...
0
votes
1answer
1k views

How to populate a table with data from tables on other sheets using a drop down list

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I ...
1
vote
0answers
261 views

Display value based from multiple dropdown list with IF, AND, SUMIFS

Attached below I show an example of what I'm trying to achieve Basically I want to have a result based on the chosen item from 2 dropdown list and a range of date. If you select "Name1" "Test 1" and ...
1
vote
0answers
270 views

Refresh drop down cell value in excel

I have a drop down cell which has a list of values. The problem is, I want to refresh the cell value to the 1st value of the list "JR" or other, whenever the I change the value on the "S235" cell. ...
0
votes
1answer
590 views

Bat to open webpage, choose from dropdown menu and automatically input proxy login

I'd like to run a bat that opens an specific webpage on Google Chrome, input proxy username and password right after launching the internet browser and pick an option from a dropdown menu. For the ...
0
votes
1answer
40 views

Excel dropdown with condition

I have searched for a while without being able to find a solution to my problem. A have a table named tbl_lov that contains the list of values used in a dropdown list via indirect function. INDIRECT("...
0
votes
1answer
675 views

Change dynamically a picture on a worksheet based on a value from a dropdown list

I use Windows 7 Professional and Excel 2013. I would like to change dynamically a picture on a worksheet based on a value from a dropdown list. I found online 2 ways that seems to fit my problem. ...
1
vote
1answer
407 views

“Link” two cells, modify one changes the other

I have a dataset that I use to generate some graphs. I have a cell in one sheet that changes my data based on the country I choose from a dropdown. I want to be able to change this dropdown from a ...
2
votes
0answers
118 views

Why are form field suggestions out of position in Chrome? [closed]

For a year or more I've had a problem with Chrome, always on the latest versions, where the suggestions dropdown is out of position. I've reset Chrome. I've disabled all extensions. Nothing resolves ...
1
vote
1answer
46 views

Next steps with accessing an Excel table from one sheet into another

I've done it once before, using a web tutorial that I cannot locate again, but now I'm trying to it again and I'd appreciate some insight in terms of “next steps” and where I am going wrong. I have ...
0
votes
1answer
582 views

Autohotkey 5-Level cascading menu

Can anybody who knows Autohotkey pls help me create a 5-level cascading menu (or at least tell me where can I find a ready-made template). See sample screenshot (diagram): The menu should work like ...
0
votes
2answers
207 views

Change an excel drop down value based on selections in other drop downs

I am trying to create a template for Risk Analysis Matrix. I have 3 drop downs in 3 columns: Column A Called "Risk Severity" with values (ACCEPTABLE, TOLERABLE,UNDESIRABLE,INTOLERABLE). Column B ...
0
votes
1answer
374 views

Create Excel chart with two y-axes: constant data on axis 1, dropdown list data on axis 2?

Comfortable with adding a second axis to, and just learned how to use a drop-down list with, an Excel chart. Can't find anything about doing both at the same time. My example: Calendar dates (or ...
0
votes
1answer
440 views

Bind dropdown with the values from 2 cells in another worksheet

I have dropdown contorl in sheet1. Then in sheet2 the values like, 'D2' value 2010, 'D3' value 2020. So now, I want to populate this dropdownlist with values 2010,2011,2012,,,,2019,2020(on workbook ...
0
votes
1answer
77 views

Create a dropdown list with a single dependant variable in the 2nd column

I've created a dropdown list of different type's of lamp fittings, I created a 2nd dropdown list with different lamp wattages. I want to setup my Excel dashboard so that if you select a lamp fitting ...
1
vote
1answer
12k views

Name manager doesn't allow spaces in EXCEL

I am creating dependent drop down list in Excel using Data validation and Name Manager and the function Indirect. My problem is that the Name Manager doesn't allow to have space when defining a new ...
0
votes
0answers
411 views

Dynamic dropdown in Excel

Trying to created a searchable dynamic dropdown containing a list of all of our products for order processing at work. It is searchable which is one of the main uses, but it only works for one of the ...