Multiple Words on a long Dropdown List Limitation

%3CLINGO-SUB%20id%3D%22lingo-sub-2599855%22%20slang%3D%22en-US%22%3EMultiple%20Words%20on%20a%20long%20Dropdown%20List%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599855%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20long%20dropdown%20list%20for%20invoicing%20purposes.%20I%20have%20close%20to%2020%20items%20to%20list%20at%20about%2035%20characters%20per%20line.%20Is%20this%20possible%3F%20I'm%20only%20half%20way%20through%20and%20I%20can't%20ad%20anything%20else.%20Can%20I%20change%20the%20limit%20value%20for%20the%20amount%20of%20lines%3F%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2599855%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2600042%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Words%20on%20a%20long%20Dropdown%20List%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2600042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118724%22%20target%3D%22_blank%22%3E%40EMart44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20enter%20the%20list%20of%20items%20directly%20in%20the%20Source%20box%20in%20the%20Data%20Validation%20dialog%2C%20you're%20limited%20to%20a%20total%20of%20255%20characters.%3C%2FP%3E%0A%3CP%3EBut%20if%20you%20enter%20the%20items%20in%20a%20column%2C%20one%20per%20row%2C%20you%20can%20point%20to%20the%20range%20in%20the%20source%20box.%20that%20way%2C%20you%20can%20make%20the%20list%20as%20long%20as%20you%20want.%20The%20source%20range%20can%20be%20on%20the%20same%20worksheet%20or%20on%20another%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

2 Replies

@EMart44 

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.

Thank you, Sir. I will try that.