Microsoft Excel And Drop Down Lists

Good Day,

We have an Excel Spreadsheet that has a drop down list in a range of cells. (See attached screenshot). Unfortunately, the font size of the list items is too small for some of our elder users. I cannot find anyway to increase this size. Can anyone advise?

Thanks,

Milty

http://img156.imageshack.us/img156/8378/listim2.gif

 

The short answer is you can't mada.

The longer answer is you can change the windows display settings for windows components such as drop down lists and this MAY apply to excel.

The even longer answer is you can write some vbscript to adjust the zoom when you select a certain cell, and then put it back when your done (this could be a bit jumpy lol)

 

Damn....what was Microsoft thinking?!?!?

I'll let our user try that.

*checks watch*
I'm going to pretend I didn't see you write that.

Thanks, Matt!

 

No problem Mada

 

This might be another work-around.

Unfortunately, there is no way to change the size of the font. The font size used for some Excel controls is modified whenever you change the display properties in Windows, but none of those affect the drop-down font, either.

Because the font size increases in proportion to the zoom factor used for a worksheet, there is one potential workaround. You could increase the zoom factor a significant amount, say to 100% or even 125%. Then, select the data in the worksheet and decrease the font size and adjust column widths so you can see as much of the worksheet as you could at the 60% zoom factor. The change in worksheet font size should not affect the drop-down font size. That should still be tied to the zoom factor, and now be large enough to easily read.

Steve