I HAVE A 175 NAME DROP DOWNLIST.IN CELL IS SMALL.HOW CAN I ZOOM
 

WHEN THE LIST ISPLACED ON A COLUMN OF CELLS THE FONT IS ALMOST UNREADABLE

HOW CAN I INCREASE THE DROP DOWN LIST FONT SIZE WITHIN A CELL

I HAVE A 175 NAME DROP DOWNLIST.IN CELL IS SMALL.HOW CAN I ZOOM
 

If you increase the cell font size for a particular column which consist the
Validation List then the row size also will be increased. In this case you
can use Cntrl+Mouse Scroll Button (upwards) to increase the zoom, (downwards)
to decrease the zoom.

At the same time whenever you post a new message or giving reply to a post
dont type it in Block Letters€¦

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"TONY" wrote:

WHEN THE LIST ISPLACED ON A COLUMN OF CELLS THE FONT IS ALMOST UNREADABLE

HOW CAN I INCREASE THE DROP DOWN LIST FONT SIZE WITHIN A CELL

I HAVE A 175 NAME DROP DOWNLIST.IN CELL IS SMALL.HOW CAN I ZOOM
 

You cannot change the size of the font in a DV list.

Debra Dalgleish has code to toggle Zoom level up/down when selecting a DV
cell.

http://www.contextures.on.ca/xlDataVal08.html#Larger

Adjust the range to suit.


Gord Dibben MS Excel MVP

On Sun, 4 Oct 2009 22:09:01 -0700, TONY <TONY @discussions.microsoft.com
wrote:

WHEN THE LIST ISPLACED ON A COLUMN OF CELLS THE FONT IS ALMOST UNREADABLE

HOW CAN I INCREASE THE DROP DOWN LIST FONT SIZE WITHIN A CELL