Dear all,

I have used data validation to restrict user inputs for a cell using: Data
validation, the list option and selecting "in-cell dropdown" menu.

However the worksheet has been zoomed to 60% and the list in the dropdown is
now unreadable.

Is there a way to increase the font of the dropdown list?


In appreciation,

Neil

Hi Neil

The default font is 8 pt and cannot be changed. Check out the below link by
Debra Dalgleish.

http://www.contextures.on.ca/xlDataVal08.html#Font

If this post helps click Yes
---------------
Jacob Skaria


"Neil Pearce" wrote:

Dear all,

I have used data validation to restrict user inputs for a cell using: Data
validation, the list option and selecting "in-cell dropdown" menu.

However the worksheet has been zoomed to 60% and the list in the dropdown is
now unreadable.

Is there a way to increase the font of the dropdown list?


In appreciation,

Neil

Try Debra's page at:
http://www.contextures.com/xlDataVal08.html

Scroll down a little for the topics:
Data Validation Font Size and List Length
Make the Dropdown List Appear Larger, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Neil Pearce" wrote:
I have used data validation to restrict user inputs for a cell using: Data
validation, the list option and selecting "in-cell dropdown" menu.

However the worksheet has been zoomed to 60% and the list in the dropdown is
now unreadable.

Is there a way to increase the font of the dropdown list?