Drop down list

  • Thread starter Thread starter Hrider
  • Start date Start date
H

Hrider

When I create a drop down list for a cell the font is too small. How can I
increase the size so I can read it better?
 
You can't change the font or font size for a Data Validation dropdown
list. To make the font appear larger, you can use programming to adjust
the zoom setting when the cell is selected. There's sample code here:

http://www.contextures.com/xlDataVal08.html#Larger

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
thecombobox, you can set the font size:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'
 
You must log in or register to reply here.

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 and error message 1
Changing font size in data validation drop-down lists 1
Data Validation and drop-down list using IF, AND and what else? 8
Drop Down List 2
combobox 4
data validation list 17
Drop Down list font too small... help please 4
Drop down list from index/match formula 1

Back
Top