Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

dropdown list length

Copper Contributor

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?

 

4 Replies

@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.

@Hans Vogelaar 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?

 

@Steve573 

You can use a source such as

=$Z$2:$Z$100

or

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

Thank you, I will try that