Thread: How do you format data that is part of a drop down menu?
View Single Post
  #4  
Old July 10th, 2008, 05:47 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
  
Posts: 20,252
Default How do you format data that is part of a drop down menu?
What type of dropdown is it?

If DV dropdown list just select the cell then DataValidation

Look in the "Source" dialog for a range or range name.

If a Comboxbox from the Control Toolbox, open Control Toolbox and go into Design
Mode then right-clickPropertiesListFillRange


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:57:01 -0700, Sassy Sassy @discussions.microsoft.com
wrote:

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"