How to Change Font Size in Excel

[wec43wec]

How do you control the font size in the Data / Validation / "List" dropdown box in Excel without changing the "zoom" percent from the menu bar and without using VBA?

Note: I do not want to change the cell font size, just the display of text font size from the dropdown box.

 

[GlennUK]

You can't.

You've obviously heard about changing the zoom, and about messing with VBA ( to change zoom on selection ). I generally reduce my font size over the whole sheet and zoom in a bit.

Otherwise you could embed an object to behave like a drop-down? Like this:

http://www.contextures.com/xlDataVal08.html#Font

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[macropod]

You can change the font size via the Windows Control Panel, but this affects all applications.

Cheers
Paul Edstein
[MS MVP - Word]

 

[wec43wec]

Thanks guys, I guess I can not change it without VBA.