Thread: How do you format data that is part of a drop down menu?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do you format data that is part of a drop down menu?
You cannot change the font size in a DV dropdown.

There are workarounds.

See Debra Dalgleish's site for these.

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


Gord Dibben MS Excel MVP

On Sat, 16 Sep 2006 07:30:02 -0700, Jester
wrote:

If you use a drop down menu list with data validation, the menu is so small
you can't read it. How do you apply normal formatting to improve the
situation (font size, bold, etc.)

Reply With QuoteReply With Quote