View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default xls data validation question 2

Input your choices into some cells in the workbook, and then under data
validation, list you can callout those cells
=A2:A10

--
Best Regards,

Luke M
"t" wrote in message
...
i am able to create a list "drop down" through data validation. my problem
is
my choices are sentences, and i can only use so many characters in the
list.
i run out of characters before i input my sentence choices. is there a way
to
allow more/unlimited text???