Aug 08 2020 08:40 AM
I created a drop down using Data Validation and need to know if there is a limit to the list items? IF so, is ther a work around? I need to have
Aug 08 2020 09:00 AM
Aug 08 2020 09:09 AM
If you mean text length for the items, when 254 characters.
Aug 08 2020 09:22 AM
Correctly observed :-).
Not the Excel cell is limited, only the input field for the list.
Solution:
Solution:
You write the list one below the other in a free area, e.g. in from J28 down to J38.
Without a comma.
In the data validity you then state as "source"
= $ J $ 28: $ J $ 38
Thx
Nikolino