Aug 02 2021 01:40 PM
I'm trying to create a long dropdown list for invoicing purposes. I have close to 20 items to list at about 35 characters per line. Is this possible? I'm only half way through and I can't ad anything else. Can I change the limit value for the amount of lines? Please help.
Aug 02 2021 01:46 PM
If you enter the list of items directly in the Source box in the Data Validation dialog, you're limited to a total of 255 characters.
But if you enter the items in a column, one per row, you can point to the range in the source box. that way, you can make the list as long as you want. The source range can be on the same worksheet or on another one.
Aug 02 2021 02:31 PM