ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Validation Font Size varies (https://www.excelbanter.com/excel-programming/396222-validation-font-size-varies.html)

scottydel

Validation Font Size varies
 
Hello,

I'm using Excel 2003. I have a workbook with two worksheets, both of which
have Data Validation cells. On one worksheet, the font size of the
validation drop-down list is larger than on the other. The drop-down lists
are using identical values.

There seems to be something inherently different about one worksheet which
makes all of its validation drop-downs use a small font, while the other
worksheet does not have this problem.

I have read elsewhere that you cannot change the font size on validation
drop-downs.

Any ideas why a different worksheet would use different font sizes?

Thanks,

Scott

scottydel

Validation Font Size varies
 
I dug a little deeper and the zoom was set to 70% which I had read about but
never thought to check!

"scottydel" wrote:

Hello,

I'm using Excel 2003. I have a workbook with two worksheets, both of which
have Data Validation cells. On one worksheet, the font size of the
validation drop-down list is larger than on the other. The drop-down lists
are using identical values.

There seems to be something inherently different about one worksheet which
makes all of its validation drop-downs use a small font, while the other
worksheet does not have this problem.

I have read elsewhere that you cannot change the font size on validation
drop-downs.

Any ideas why a different worksheet would use different font sizes?

Thanks,

Scott


Dave Peterson

Validation Font Size varies
 
Any chance that the zoom factor is different?

scottydel wrote:

Hello,

I'm using Excel 2003. I have a workbook with two worksheets, both of which
have Data Validation cells. On one worksheet, the font size of the
validation drop-down list is larger than on the other. The drop-down lists
are using identical values.

There seems to be something inherently different about one worksheet which
makes all of its validation drop-downs use a small font, while the other
worksheet does not have this problem.

I have read elsewhere that you cannot change the font size on validation
drop-downs.

Any ideas why a different worksheet would use different font sizes?

Thanks,

Scott


--

Dave Peterson

scottydel

Validation Font Size varies
 
Yes, I caught that and posted but must have been around the same time as
you....

Thanks Dave.

"Dave Peterson" wrote:

Any chance that the zoom factor is different?

scottydel wrote:

Hello,

I'm using Excel 2003. I have a workbook with two worksheets, both of which
have Data Validation cells. On one worksheet, the font size of the
validation drop-down list is larger than on the other. The drop-down lists
are using identical values.

There seems to be something inherently different about one worksheet which
makes all of its validation drop-downs use a small font, while the other
worksheet does not have this problem.

I have read elsewhere that you cannot change the font size on validation
drop-downs.

Any ideas why a different worksheet would use different font sizes?

Thanks,

Scott


--

Dave Peterson



All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com