Excel.Tips.Net ExcelTips (Menu Interface)

Changing Fonts in Data Validation Drop-Down Lists

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Changing Fonts in Data Validation Drop-Down Lists.

Frederick has created some simple drop-down lists for some cells using data validation. He wants to know if there is a way to change the font used to display the entries in the drop-down lists.

The short answer is no, there is not. You can adjust the apparent size of the font by adjusting the zoom value for a worksheet, but that is about it. If you want more control over the font, then you will need to use a different approach to drop-down lists, such as using a combo box from the Control toolbox.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3264) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Changing Fonts in Data Validation Drop-Down Lists.

Related Tips:

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

Michael Avidan - MVP    22 Sep 2012, 06:08
Two, simple, Event Macros will be glad to assist, any Excel user, to work around this "problem".

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   ZM = 100 : ZDV = 140
   Application.EnableEvents = False
   On Error Resume Next
   DVT = Target.Validation.Type
      On Error GoTo ExitHandle
      If DVT <> 3 Then
          If ActiveWindow.Zoom <> ZM Then ActiveWindow.Zoom = ZM
          If ActiveWindow.Zoom <> ZDV Then ActiveWindow.Zoom = ZDV
     End If
    Application.EnableEvents = True
    Exit Sub
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
    ActiveWindow.Zoom = 100
End Sub

Michael Avidan
"Microsoft®" MVP – Excel

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.