Thread: Data validation function and drop-down lists
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default Data validation function and drop-down lists
Hi Colleen

As Tom rightly says, there isn't.
However there are a few "tricks" to achieve this if you take a look at
Debra Dalgleish's site
http://www.contextures.com/xlDataVal08.html#Larger
http://www.contextures.com/xlDataVal08.html#Wider

or by adding a Combo Box to the sheet
http://www.contextures.com/xlDataVal10.html


--
Regards

Roger Govier


"Colleen" wrote in message
ink.net...
I am sending this to several newsgroups, because I am not sure which
one
is the most appropriate.

I am using the "Data Validation" function of Excel to create drop-down
lists. Is there any way to control the font size of the items in the
drop-down list without changing the zoom (view) function of the whole
spreadsheet?

Thank you.
Colleen


Reply With QuoteReply With Quote