Can I make the data validation dropdown list expand to show more choices?

[MrBadEXCEL]

I have several data validation dropdown lists [not combo boxes from the developer tab] that have more than 12 items in them.
Is it possible to edit the list's format so they display more items in the list when the dropdown is clicked?

 

[Crystalyzer]

I don't believe the standard data validation drop down can be expanded, however, I did find this link that suggests another way to go about it.

How to show/display more than 8 lines in data validation list in Excel?

 

[Peter_SSs]

To be honest, I have not studied in detail the link provided by Crystalyzer, but here is another one that may be worth a look too.
Show Excel Data Validation Drop Down Items in Combo Box

 

[johnnyL]

I didn't mention combobox because the OP specifically mentioned, "not combo boxes". That is the only path that I have found though.

 

[Peter_SSs]

I didn't mention combobox because the OP specifically mentioned, "not combo boxes".

The OP said they didn't have combo boxes, not specifically that they wanted a solution without them so I thought worth a mention.

 

[johnnyL]

The OP said they didn't have combo boxes, not specifically that they wanted a solution without them so I thought worth a mention.

True enough! I just figured since it was mentioned, it was not wanted. I have been wrong too many times in the past. I guess we will see if that route is acceptable. I certainly meant no disrespect, so my appologies if you inferred my post as that.

 

[Peter_SSs]

No apology needed.

 

[MrBadEXCEL]

True enough! I just figured since it was mentioned, it was not wanted. I have been wrong too many times in the past. I guess we will see if that route is acceptable. I certainly meant no disrespect, so my appologies if you inferred my post as that.

I didn't mention combobox because the OP specifically mentioned, "not combo boxes". That is the only path that I have found though.

Yes, that's why I mentioned it. I didn't want to use them. Thanks. I didn't think there was a way to edited the list.

 

[johnnyL]

Woohoo!!! What do I win? Ahh nevermind, nobody ever wins .

 

[ravi2628]

Hi,

I have Tried This Logic Can you Please check if Possible

the filter will change Dynamically

Book1
	G	H	I	J	K	L	M
1					Drop Down List
2	2018	Yellow	2018 Yellow		0		2018 Yellow
3	2018	Blue	2018 Blue		2018 Yellow
4	2018	Red	2018 Red		2018 Blue
5	2018	Yellow	2018 Yellow		2018 Red
6	2018	Blue	2018 Blue		2017 Yellow
7	2018	Red	2018 Red		2017 Blue
8	2018	Yellow	2018 Yellow		2017 Red
9	2018	Blue	2018 Blue		2017 Green
10	2018	Red	2018 Red		2017 Violet
11	2017	Yellow	2017 Yellow		2017 Pink
12	2017	Blue	2017 Blue
13	2017	Red	2017 Red
14	2017	Green	2017 Green
15	2017	Violet	2017 Violet
16	2017	Red	2017 Red
17	2017	Yellow	2017 Yellow
18	2017	Blue	2017 Blue
19	2017	Red	2017 Red
20	2017	Pink	2017 Pink
Mapping Data

Cell Formulas
Range	Formula
K2:K11	K2	=UNIQUE(I:I,0,0)
I2:I20	I2	=CONCATENATE(G2," ",H2)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
M2	List	=$K$2:$K$19

Data Validation List selected till highlighted Range.