| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is it possible to re-size or format list items in dropdown box?
i have created several drop-down lists using the data/validate function in
Excel, but the font / size of the list items in the drop-down list are too small to read... |
|
#2
|
|||
|
|||
|
For a data validation dropdown list, you can't change the font size.
There are a couple of workarounds he http://www.contextures.com/xlDataVal08.html#Font Or, there's a sample file here that provides a combobox from which you can select one of the values from the data validation list. In the combobox, you can change the font size: http://www.contextures.com/excelfiles.html jc wrote: i have created several drop-down lists using the data/validate function in Excel, but the font / size of the list items in the drop-down list are too small to read... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format control of a list box | Excel Worksheet Functions | |||
| maximum size of a Microsoft Excel list for a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions | |||
| Changing font size in a list box | Excel Discussion (Misc queries) | |||
| how to increase the font size in a dropdown list? | Excel Worksheet Functions | |||
Linear Mode
