Hello Debra and Bob,

Thank you for your answers. Unfortunately I'm not accustumed with
programming, VBa and other comboboxes ( I wonder if comboboxes exist in the
french version). The drop down list in the "name bar" ( left top of screen)
is longer than my drop list and still readable. I didn't see it before but
the question has been asked many times before and I think the problem has to
be adressed to by Microsoft like the automatic height of murged cells and a
couple of others.

68magnolia71

"Bob Phillips" wrote:

No, you need a combobox for this.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"68magnolia71" wrote in message
...
Hello every one,

I use quite a lot of drop down lists in a work book and some of them are
pretty long. The question is: is there a way to pouch in the first letter
of
a word ( the list is arranged in alphabetical order) so as the list goes
to
that postion?
Thank you for any suggestion.

68magnolia71