A Very Long Drop Down List

I really wouldn't have a 30,000 element drop-down. The GUI is supposed to make it easier on the user rather than harder. If you have no other way to categorise the data other than alphabetically, you're not restricted to using a two-stage approach with just the first character. Make it reliant on the first two characters.

I currently have a drop down menu, with 30 items in it, but it only displays 8. Hi, If as I suspect this is a data validation list then you can't. Eight is the only setting and to get more you should consider a combobox from the ActiveX toolbox on the developer tab.

I am new to excel and I am trying to create a drop down list of descriptions for an expense report. All that I find is help using comma separated which limits my entries to only approx 8 items. How do I create a very long list of items to choose from in a column of cells? Please help!confused

In one of the project, I replaced huge dropdowns with the modal dialog which has a table and filters at top. call it Popup lookup table. So, instead of a dropdown, i put a readonly text box, just beside the text input theres a link which says 'select', when user click the link, it opens modal dialog with a table and filters at the top, user can search throw data, and select one of the row

Searchable dropdown is now available in current and monthly channel. Data Validation dropdown list autocomplete Dropdown lists are a handy way to make data entry and validation more efficient in Excel. We've now added AutoComplete functionality, which automatically compares the text typed in a cell to all items in the dropdown list and displays only the items that match.

Use the Drop Down List. Select the cell with the data validation list, and click the drop down arrow. If the cell does not contain the text quotFull Listquot, the drop down will show the short list of top customers. If you need to see the full list, select quotFull Listquot from the top of the drop down list, and then click the drop down arrow again.

However, if your list is too long to comfortably fit within the standard drop down size, there are several methods you can use to increase its size. For very large drop down lists, consider adding a search box to allow users to quickly locate specific items. C. Avoiding common pitfalls when increasing the size of drop down lists.

This can be a very long list. Media Temple had implemented a technique where as you scroll down, the menu actually moved in an accelerated fashion. I just can't seem to 'Take that 1st drop-down list, keep it expanded' as you said it. Have you found a way to do this? Thanks in advance. Leif Miltenberger. Permalink to comment November

Adding a long drop-down list I'm creating a Form and have a long list of employees in an Excel file already. I'd like to be able to copy that list and paste it in MS Forms instead of having to input each name one-by-one.

There is a chance that you've heard more than once about an Excel drop-down list, aka dropdown box or dropdown menu. This feature is an integral part of the data validation tools in Excel. Limiting the set of possible values to a predefined list in Excel data validation tools can reduce data entry inaccuracies. Users can select from a drop-down