Drop down box font size

[Francis Hookham]

XL 2004 Drop down box font size appears to be same as font used in the sheet

When the same workbook is opened in XL 2002, the 12pt Arial in the sheet
appears to be about 8pt in the drop down box

Anyway of controlling Drop down box font size?

Francis Hookham

 

[Priyanka Singhal [MSFT]]

Drop down box font sizeHi Francis,
I am not sure about the exact dropdown you are talking about . If it is a dropdown on the toolbars or the formatting palette then the font size is fixed . it cannot be changed and does not depend on the font used in the sheet . Is it possible that the resolution of the screen you are using ?
because that is one reason why you'd feel the size is different .

Thanks,
Priyanka
XL 2004 Drop down box font size appears to be same as font used in the sheet

When the same workbook is opened in XL 2002, the 12pt Arial in the sheet appears to be about 8pt in the drop down box

Anyway of controlling Drop down box font size?

Francis Hookham

 

[CyberTaz]

I believe this may relate to the old Mac res = 72 ppi, Win res = 96 ppi
kettle of fish cooked up so often in the Word ng. Assuming the same monitor
setting (eg., 1024 x 768) text will appear 25% smaller on the PC than on the
Mac. Assuming font compatibility, however, the file should print the same on
either system.

Regards |:>)