View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Data Validation List: Text Size Query

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