In excell 2003, increasing number of items shown in drop down list

S

Sekani

I am trying to increase the number of lines to be displayed in the drop down
list, using MS office 2003, excell. I have read contributions to the question
possed on 8/11/2007 8:00 PM , but sadly it does not provide the "Format
Control" that should enable me to change the mnumber of dropdown lines to be
shown.

I have 30 items on my soure list and only 12 appear in the dropdown list.
How and where can I adjust the figure that dictates the lines to be shown?
How do I go about it as I do not see any options leading to the data
validation combo box in this version?

Thanks a million for the responses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list function help 2
Can I increase the view of a drop down list beyond 8 in Excel? 2
how do I increase the length of a drop down list? 1
Formatted cell column in drop down list 1
drop down list 3
Drop-down list and error message 1
totaling data from a drop down list 2
Setting up conditional drop down lists in Excel 2003? 1

Top