Jul 21 2022 03:41 AM
Is there a limit to how many characters you can type into the Data validation source box having chosen List?
Jul 21 2022 03:47 AM - edited Jul 21 2022 04:27 AM
@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.
Jul 21 2022 03:49 AM
As Riny mentioned, it is best to enter the address of a range in the Source box.
If you enter the list directly into the Source box, the limit is 255 characters.