Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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.) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
You cannot change the font size in a DV dropdown.
There are workarounds. See Debra Dalgleish's site for these. http://www.contextures.on.ca/xlDataVal08.html#Larger Gord Dibben MS Excel MVP On Sat, 16 Sep 2006 07:30:02 -0700, Jester wrote: 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.) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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!!! " |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! " |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! " |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! " |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
I cannot believe it's this difficult to simply remove names from a drop down
list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
"Gord Dibben" wrote: 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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
I simply want to add another name to the DV list that I already have created.
How? "Gord Dibben" wrote: 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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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 On Wed, 13 Aug 2008 07:52:19 -0700, Seeker wrote: I simply want to add another name to the DV list that I already have created. How? "Gord Dibben" wrote: 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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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?)? "Gord Dibben" wrote: 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 On Wed, 13 Aug 2008 07:52:19 -0700, Seeker wrote: I simply want to add another name to the DV list that I already have created. How? "Gord Dibben" wrote: 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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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 On Thu, 14 Aug 2008 12:58:00 -0700, Nur wrote: 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?)? "Gord Dibben" wrote: 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 On Wed, 13 Aug 2008 07:52:19 -0700, Seeker wrote: I simply want to add another name to the DV list that I already have created. How? "Gord Dibben" wrote: 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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
Do you know how to format a drop down box where the arrow to the right of the
box does not disappear? "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!!! " |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
Yes.
Use a CombobBox from the Control ToolBox Toolbar. Gord On Fri, 15 Aug 2008 10:09:29 -0700, jr wrote: Do you know how to format a drop down box where the arrow to the right of the box does not disappear? "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!!! " |
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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 "Nur" wrote: 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?)? "Gord Dibben" wrote: 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 On Wed, 13 Aug 2008 07:52:19 -0700, Seeker wrote: I simply want to add another name to the DV list that I already have created. How? "Gord Dibben" wrote: 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 DataData ValidationDataData Tools or somesuch command. You will have to find that dialog for yourself on the worksheet menubar. Gord On Thu, 10 Jul 2008 13:35:03 -0700, Sassy wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#19
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
Read my reply to NUR for the answer.
"Sassy" wrote: 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... "Gord Dibben" wrote: 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 On Thu, 10 Jul 2008 12:40:02 -0700, Sassy wrote: I cannot believe it's this difficult to simply remove names from a drop down list...I'm dying over here...lol "Gord Dibben" wrote: 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!!! " |
#20
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
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! :) "Gord Dibben" wrote: You cannot change the font size in a DV dropdown. There are workarounds. See Debra Dalgleish's site for these. http://www.contextures.on.ca/xlDataVal08.html#Larger Gord Dibben MS Excel MVP On Sat, 16 Sep 2006 07:30:02 -0700, Jester wrote: 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.) |
#21
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format data that is part of a drop down menu?
You can change the color after the item has been selected.
Either through CF or event code. In 2007 you can have 64 CF rules in a cell. In 2003 only 3 rules for a cell. Event code could look like this. Assumes A1 is DV dropdown. Private Sub Worksheet_Change(ByVal Target As Range) Set r = Range("A1") If Intersect(Target, r) Is Nothing Then Exit Sub End If vals = Array("C", "D", "G", "H", "K", "L", "O", "S", "C", "X") 'your items nums = Array(8, 9, 6, 3, 7, 4, 20, 10, 8, 15) With Target icolor = 0 For i = LBound(vals) To UBound(vals) If UCase(r.Value) = vals(i) Then icolor = nums(i) End If Next If icolor 0 Then .Font.ColorIndex = icolor End If End With End Sub If you have many items in your list you may want to employ a lookup table for vals and nums arrays. Gord On Thu, 10 Dec 2009 12:08:01 -0800, Kirk wrote: 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! :) "Gord Dibben" wrote: You cannot change the font size in a DV dropdown. There are workarounds. See Debra Dalgleish's site for these. http://www.contextures.on.ca/xlDataVal08.html#Larger Gord Dibben MS Excel MVP On Sat, 16 Sep 2006 07:30:02 -0700, Jester wrote: 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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why would Show All not be active in Filter part of Data menu? | Excel Worksheet Functions | |||
Getting data from a sub-totalled list to other lists | Excel Discussion (Misc queries) | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
the format data - not formatted | New Users to Excel | |||
Sort pages? | Excel Discussion (Misc queries) |