dropdown list length

[Steve573]

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?

[#2]

@Steve573 

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.

[#3]

@HansVogelaar 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?

[#4]

@Steve573 

You can use a source such as

=$Z$2:$Z$100

or

=OFFSET($Z$2,0,0,COUNTA($Z$2:$Z$1000000),1)

[#5]

Thank you, I will try that