-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
data validation list format font size
- Thread starter ATMlady
- Start date
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
Nope. Only way is to increase the Zoom on the worksheet, which may or may not be an option.
Upvote
0
This is not a VBA form or anything; it's the data validation by list that you do by going thru the menus - data, validation, settings, allow list, choose the range of cells that contains the list. Size of list area is one column, however many rows, size of drop down box depends on how big you make the cell where you insert the box. But the text inside the box, once you click on the arrow, is teeny tiny and I think impossible to change, unless I change some default somewhere ....
Upvote
0
santeria
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,844
Most of the Time I find the Lists are small font if I have heaps of data.
Last one I did, I controlled the Data display from two other cells.
The principle thing was that the List was a link for me to get data strings... I never really used the list itself to display info, ... Well a few times, but I had to open up the size of the list.
That zoom suggestion works when editing, but no good for Practical purposes. Great on my Home Monitor, since I can usually see more than a regular page on that one compared with the CRT I am staring at now
Last one I did, I controlled the Data display from two other cells.
The principle thing was that the List was a link for me to get data strings... I never really used the list itself to display info, ... Well a few times, but I had to open up the size of the list.
That zoom suggestion works when editing, but no good for Practical purposes. Great on my Home Monitor, since I can usually see more than a regular page on that one compared with the CRT I am staring at now
Upvote
0
