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 control value in vba 2
Drop down lists in seperate columns 5
Duplicate hashtags in OneNote 0
list or combo box 0
Limit drop down items based on another cell 3
Formatted cell column in drop down list 1
Validation of cell based on Drop down list 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6

Top