View Single Post
  #6  
Old July 10th, 2008, 08:34 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?

I am not familiar with the commands in 2077 so will have to leave this for
someone else.

Or see Ron de Bruin's site for where to find the commands in 2007 menus.

http://www.rondebruin.nl/0307commands.htm


Gord

On Thu, 10 Jul 2008 11:35:18 -0700, Sassy
wrote:

It's a drop down that has several names in it and I still cannot seem to edit
the names to make this doc work. I also, cannot find the combo or control box
within excel 2007...Please help!

"Gord Dibben" wrote:

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!!!

"