If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
increase number of items shown in drop down list?
The responder gave you instructions for a ComboBox from the Control Toolbox.
You are using Data Validation dropdown list so won't have the "Format Control" DV dropdowns cannot be extended to show all items. Perhaps you might want to use a ComboBox in conjunction with the DV. In that case see Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal14.html Note: a ComboBox also gives you autocomplete function which DV cannot provide. Gord Dibben MS Excel MVP On Wed, 11 Feb 2009 14:04:00 -0800, lenesila wrote: I tried this and no "Format Control" shows in the menu. I have office 2007. "Jollymon67" wrote: Rght click over the drop down menu. Select "Format Control" from menu. Click on "Control" tab. You should see a line that says "Drop down lines:" and then a box with a number in it. Increase the value of the number in this box to a value equal to, or greater than the number of lines you need to display. Select OK "kojaks43" wrote: Using Excel 2007 - Home edition. Created a list and placed drop down using data validation. The drop down window shows some of the entries with a scroll bar. Can I increase the size of the drop down so the scroll bar goes away? Thanks k |
#12
|
|||
|
|||
increase number of items shown in drop down list?
Gord,
I have tried creating a Combo Box in Excel 2007 but cannot seem to find how to change the font of the box contents nor start the auto-complete function. Any ideas? "Gord Dibben" wrote: The responder gave you instructions for a ComboBox from the Control Toolbox. You are using Data Validation dropdown list so won't have the "Format Control" DV dropdowns cannot be extended to show all items. Perhaps you might want to use a ComboBox in conjunction with the DV. In that case see Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal14.html Note: a ComboBox also gives you autocomplete function which DV cannot provide. Gord Dibben MS Excel MVP On Wed, 11 Feb 2009 14:04:00 -0800, lenesila wrote: I tried this and no "Format Control" shows in the menu. I have office 2007. "Jollymon67" wrote: Rght click over the drop down menu. Select "Format Control" from menu. Click on "Control" tab. You should see a line that says "Drop down lines:" and then a box with a number in it. Increase the value of the number in this box to a value equal to, or greater than the number of lines you need to display. Select OK "kojaks43" wrote: Using Excel 2007 - Home edition. Created a list and placed drop down using data validation. The drop down window shows some of the entries with a scroll bar. Can I increase the size of the drop down so the scroll bar goes away? Thanks k |
|
Thread Tools | |
Display Modes | |
|
|