Larger font in a dropdown list?

Solved
Mélanie -  
 godlords -
Hello

I have a dropdown list in an Excel file, created by the validation function, and I would like, if possible, for the font to be larger in the list.

Is it possible? And if so, how?

Here is my example:

http://imagik.fr/view-rl/99243

Thank you
Configuration: Windows XP Internet Explorer 6.0

6 réponses

argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
Hello,

We can also, with the validation function, increase the font size of the validation list:
- Zoom the sheet to about 140%, more or less as needed
- Make adjustments by setting the entire sheet to font size 7 or 8 and adjusting the height and width of the rows and columns to restore the appearance of a normal document at 100%.
The characters in the validation list are therefore significantly larger, in proportion to the requested zoom.

It's a bit of a makeshift solution, but it helps.

--

Argitxu
24
PMD
 
it works impeccably

I had been looking for months to expand this dropdown list

it's not a hack, it's efficiency

awesome
0
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474 > PMD
 
1
AchilleExcel237 > PMD
 
Really not DIY. It's an effective and elegant solution!
0
godlords
 
really, that checks out, thank you very much :)
0