Forum Discussion

Steve573's avatar
Steve573
Copper Contributor
Nov 29, 2023

dropdown list length

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 f...
excel
Steve573's avatar
Steve573
Copper Contributor
Nov 29, 2023

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?

 

HansVogelaar's avatar
HansVogelaar
MVP
Nov 29, 2023

Steve573 

You can use a source such as

=$Z$2:$Z$100

or

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

  • Steve573's avatar
    Steve573
    Copper Contributor
    Nov 29, 2023
    Thank you, I will try that

Resources