•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Dropdown list error with listing data
Our take
If you’ve encountered a dropdown list error where your data appears in a single line instead of a formatted list, you’re not alone. This common issue often stems from how the data is structured or formatted in your spreadsheet. Understanding the underlying cause can empower you to transform your approach, ensuring your dropdowns function as intended. By exploring the correct methods for organizing your data, you can create a more efficient and user-friendly experience.
Why my data appear in a single line instead of a list?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Trying EVERYTHING. I need a drop down list to allow for clickable hyperlinks to external websites.Ok. So I have the drop down list created through data validation (="Report Lists'!$A$1:A$40). It allows me to select the external report names which have embedded URL's. The problem is, it clears the hyperlink on the drop down and makes it plain text. So... What I've found, is to create a =HYPERLINK column next to the drop downs. The problem with that however, is it states "Cannot open the specified file" as it tries to open the text instead of the embedded hyperlink. I cant just directly use the web address as the text name because they are super long, undistinguishable web address names. Any help please? submitted by /u/Gethixit [link] [comments]
- Drop down list from discontinuous cells not workingI have to make a bunch of drop downs referencing a seperate sheet that I cant really edit. some of the lists need to reference cells that arent all contiguous. For instance data validation list on =Sheet1!$A$1,Sheet1$C$1, Sheet!$D$1 yields a "You may not use reference operators for data validation critera" But leaving B1 in there works. i.e. =Sheet1!$A$1:Sheet!$D$1 works. Any way around this? submitted by /u/223specialist [link] [comments]
- Drop-down list dependant on two other cellsI have a file where I want a drop-down list in cell D14 that is based on cell D10 and D12. I have looked online and saw lot of videos that are dependant on one cell with the indirect formula, but not two. https://preview.redd.it/ptykf9yzrrwg1.png?width=289&format=png&auto=webp&s=6c0fe00c73c3d45816229bcba5fe2f1733bff083 So for example, if I had this random data and I chose Animal in cell D10, Red in cell D12, I would expect to see 33 and 2 in the drop-down menu of cell D14. Is this possible? The data is in another tab called Data and the info is in column F (F3:F1000) that should appear in the drop-down menu of cell D14. D10 and D12 are both drop-down menus if that matters submitted by /u/LookAtThosePepperoni [link] [comments]
- Data validation drop down not returning all optionsDrop down looking at 120,000 rows of a separate worksheet. Auto complete works for many but not all options. The filter option on the worksheet containing the list also falls to return these "problem cells". I've tried using get and transform but still can't get it to work. submitted by /u/donnie1977 [link] [comments]