Fonts and dropdown lists (Excel 2000)

Topic

New Reply

What about the ‘apparent’ font size in dropdown filter list boxes?
What you see, reasonably enough, depends on the zoom setting of the window, and it can be hard to reach a compromise.

Reply | Quote

Replies

The apparent size is related almost wholly to the ZOOM. If you want them to appear smaller decrease the zoom, to make it larger increase the zoom

You can then change the font size of the cell contents (format – cells) to adjust the contents to match. It is not a perfect way to do it, but it is the easiest.

The alternative is to create your own comboboxes using the control toolbox items, which allow you control over the size, color, style, etc.

Steve

Reply | Quote

The apparent size is related almost wholly to the ZOOM. If you want them to appear smaller decrease the zoom, to make it larger increase the zoom

You can then change the font size of the cell contents (format – cells) to adjust the contents to match. It is not a perfect way to do it, but it is the easiest.

The alternative is to create your own comboboxes using the control toolbox items, which allow you control over the size, color, style, etc.

Steve

Reply | Quote