How do you format data that is part of a drop down menu?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

"
 
What type of dropdown is it?

If DV dropdown list just select the cell then Data>Validation

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-click>Properties>ListFillRange


Gord Dibben MS Excel MVP
 
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!
 
I cannot believe it's this difficult to simply remove names from a drop down
list...I'm dying over here...lol
 
Probably not that difficult if you know what type of dropdown it is which you
have so far neglected to specify.

When you select a cell does an Arrow appear at right side of the cell with the
list dropdown from there?

That would most likely be Data Validation list.


Gord
 
Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
see the other names that can be clicked and selected...
 
Definitely a DV dropdown.

The list for that could be a range of cells on the sheet.

A range of cells on same or another sheet and given a defined name.

The list could be typed into the Source dialog as comma-delimited.

The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
command.

You will have to find that dialog for yourself on the worksheet menubar.


Gord
 
Gord Dibben said:
Definitely a DV dropdown.

The list for that could be a range of cells on the sheet.

A range of cells on same or another sheet and given a defined name.

The list could be typed into the Source dialog as comma-delimited.

The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
command.

You will have to find that dialog for yourself on the worksheet menubar.


Gord
Click to expand...
 
Just below "Definitely a DV dropdown." you will see three sources for DV
lists.

Just add a name to whichever list you're drawing from.


Gord
 
Hi,

I know how to create a drop down list, but how do I add a "blank" so
whoever is is filling it out can write it in (i.e. your list contains "apple"
& "banana" only and then you someone wants to enter in orange, but it's not
available on the drop down list, is there an option where they can just write
it in rather then having to chose from apple and banana?)?
 
Turn off the Error Alert option.

This will allow entering something other than what's on the list but it
won't "add" it to the list for future use.

To do that requires code.

See Debra Dalgleish's site for a sample workbook.

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord

DV0012 - Update Validation List -- type a new value in a cell that contains
data validation, and it's automatically added to the source list, and the
list is sorted; a macro automates the list updates. DataValListAddSort.zip
11 kb
 
Do you know how to format a drop down box where the arrow to the right of the
box does not disappear?
 
Man these guys like jerking you around. All you have to do is "unhide" the
cell range that the combo-box is drawing its data from. Just look for breaks
in the rows of your spreadsheet the hight the break range and unhide the
data. Its simple and much to do about nothing.

Hope this helps.

L8ters
 
Read my reply to NUR for the answer.

Sassy said:
Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
see the other names that can be clicked and selected...
Click to expand...
 
Can you change the text color in a DV Dropdown list? I would like to select
text from the Data Validation dropdown and have the resulting value selected
in the cell colored. Can this be done using Conditional Formatting somehow?
Perhaps a Macro to detect the cell contents change and change the color of
the text depending on the value? Help! :)
 
Back
Top