How do you format data that is part of a drop down menu?
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!!!
"
|