Prev: Find Duplicate names and delete problem
Next: 2 excel workbooks open up from 1 file; named :1 and :2 - why?
From: t on 12 Mar 2010 10:29
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???
From: Luke M on 12 Mar 2010 10:43
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" <t(a)discussions.microsoft.com> wrote in message
news:8F4C5071-D836-46CC-8C70-3F22D38E5177(a)microsoft.com...
>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???


From: Dave Peterson on 12 Mar 2010 10:49
Can you widen the column that holds the cell with data|validation so that the
entire sentences appear?

If not, can you show enough so that it makes sense to your users?

If you can't change the width at all, maybe you could use a key word or key
phrase that fits.


Use that as the data|validation list and then use =vlookup() to return the real
sentence to an adjacent cell.

So in B1, I could use:
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Where the data|validation list is in Sheet2 column A.



t wrote:
>
> 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???

--

Dave Peterson
 | 
Pages: 1
Prev: Find Duplicate names and delete problem
Next: 2 excel workbooks open up from 1 file; named :1 and :2 - why?