Forum Discussion
Solved
Expand amount of characters for source in data validation
Hello, I am working in excel and I am making a dropdown list with data validation. De amount of characters in the source window is too low. Is there a way to increase this? Greetings, Aar...
AaronvdHeijden Use Named Ranges and INDIRECT. I have attached a quick-and-dirty example demonstrating this. You would have to restructure your listings a bit, but it will work beautifully.
Note that Named ranges only accept normal characters, numbers and underscores and they NOT start with a number. Every sub-option will have to have it's own Named Range.
Instead of typing into the source window, type your options in a list in the workbook, then select the cells as the source.