Forum Discussion
Data Validation
Is there a limit to how many characters you can type into the Data validation source box having chosen List?
DaveM48 Not sure, but if there is one and you would risk exceeding that limit you wouldn't want to type the whole list in the source box. You would type them in a range of cells on an Excel sheet and refer to that range.