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 |
#1
|
|||
|
|||
Data Validation List: Text Size Query
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Data Validation List: Text Size Query
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? |
Thread Tools | |
Display Modes | |
|
|