A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2006, 03:30 PM posted to microsoft.public.excel.misc
jester
external usenet poster
 
Posts: 5
Default 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  
Old September 16th, 2006, 05:43 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?

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  
Old July 10th, 2008, 04:57 PM posted to microsoft.public.excel.misc
Sassy[_2_]
external usenet poster
 
Posts: 2
Default 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  
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!!!

"


  #5  
Old July 10th, 2008, 07:35 PM posted to microsoft.public.excel.misc
Sassy
external usenet poster
 
Posts: 19
Default 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  
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!!!

"




  #7  
Old July 10th, 2008, 08:40 PM posted to microsoft.public.excel.misc
Sassy
external usenet poster
 
Posts: 19
Default 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  
Old July 10th, 2008, 09:22 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?

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  
Old July 10th, 2008, 09:35 PM posted to microsoft.public.excel.misc
Sassy
external usenet poster
 
Posts: 19
Default 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  
Old July 10th, 2008, 11:49 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?

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

"







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.