• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

drop down menu

I have several cells that contain drop down menus with a rather long list.  This spreadsheet is being displayed on a large TV monitor.  When I select the drop down menu the list is very small and extremely hard to read.  Is there a way to make it larger?  I've tried formatting the cells in which the data validation source is but that did nothing.
1 Solution
Bob BenderCommented:
Well, my first thought would be to write VBA code to handle a font size change.  Maybe you could control font size, based on the # of entries in the list.

But, it would depend on *how* you created your drop down list...

If you used Data validation or the drop down from Form toolbar, you are out of luck.
If you used the drop down from Controls toolbar there's the property Font...

This following page should give you some clarification...


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now