Contents
Edit a drop-down list with items that have been entered manually
- On the worksheet where you applied the drop-down list, select a cell that has the drop-down list.
- Go to Data > Data Validation.
- On the Settings tab, click in the Source box, and then change your list items as needed.
Why would you click on the drop-down menu?
When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection. You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list. Select the cells that you want to contain the lists.
According to the Apple Style Guide (dated December 2019), the term shouldn’t be used at all: drop-down menu. Don’t use; use menu. On the other hand, Merriam-Webster lists “drop-down” and “dropdown” as equal variants for the noun form (the adjective form is always hyphenated), so maybe there’s hope for you.
What is a drop-down menu in Excel?
An Excel drop down list is a data validation function that allows users to select an option from a list of choices. It can be particularly useful in performing financial modeling. Learn to build dropdowns into models in CFI’s Advanced Excel Course.
I recently found that item in drop-down menu cannot be selected by clicking, although it can be selected by hitting “enter” on keyboard. I have no add-ons installed so that shouldn’t be the problem.
How are drop down list boxes used in InfoPath?
Drop-down list boxes are used to present an expandable list of choices to a user. When a user first opens the form, the default value, if specified, is the choice that appears in the control. To select another option, the user clicks the arrow on the side of the control and clicks the option that they want.
If the issue is not present in Firefox Safe Mode, your problem is probably caused by an extension, and you need to figure out which one. Please follow the Troubleshoot extensions, themes and hardware acceleration issues to solve common Firefox problems article to find the cause.