dropdown list length

Question

I am trying to create a dropdown list which started off OK, I am adding the selections separated by a comma, however, I cannot add enough selections, there seems to be a character limit stopping me from adding any more items. is it possible to remove this limit so I can add more items to the list?

hansvogelaar · Answer

Steve573&nbsp;
You can use a source such as
=$Z$2:$Z$100
or
=OFFSET($Z$2,0,0,COUNTA($Z$2:$Z$1000000),1)

hansvogelaar · Answer

Steve573&nbsp;
If you enter the values directly in the Source box, the total length cannot exceed 255 characters.
To get around this, enter the values in a column, one per cell. Then point to that range in the Source box.

steve573 · Answer

HansVogelaar&nbsp;thats great thanks, one more question if you could help please, I want a full column for the dropdown list which is OK but not the top heading, is it possible to do that?&nbsp;

steve573 · Answer

Thank you, I will try that

Forum Discussion

dropdown list length

4 Replies

Resources