How do I increase the font size in a cell validation list?

[Guest]

Is it possible to increase the font size in a cell validation list? To make
it work now, I have to raise the % on the sheet view to where I can't see
much of the sheet.

Thanks in advance

 

[Gord Dibben]

Font size cannot be increased.

Debra Dalgleish has some suggestions for workaround.

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


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 16:33:44 -0700, Brad Phelps <Brad

 

[Guest]

How about pasting this code into the appropriate sheet of the VB Editor. It
some code from Chip Pearson that zooms in when a particular cell is selected,
in this case A2

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$2" Then
ActiveWindow.Zoom = 120
Else
ActiveWindow.Zoom = 100
End If
End Sub