increasing size of dropdown menu



I currently have a list using validation and only so many line show up in the
drop down box. Is there a way to increase the size of the drop down box?


If you're using a combobox you can right click it, go to format control,
under the control tab you can specify how many drop down lines you want.

Is that what you're looking for?


Thanks. I tried but no joy. This is the list I have created elsewhere in the
sheet to use as the validation list. When I right click on the dropdown box
it merely selects the line I am right-clicking on. I want more of my list to
show in the dropdown box.

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