How do I create pull down menus for individual cells?
 

I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

How do I create pull down menus for individual cells?
 

Select the cells, select Data/Validation, select List, type in your list
just like you did (no quotes):
poultry, red meat, fish
then click the error Alert tab and put in whatever error message you want.
That's it.

"jirl" wrote in message
...
I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select
from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

How do I create pull down menus for individual cells?
 

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

How do I create pull down menus for individual cells?
 

Look at Data Validation

See here for a comprehensive introduction

http://www.contextures.com/xlDataVal01.html

HTH

"jirl" wrote:

I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

How do I create pull down menus for individual cells?
 

Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

How do I create pull down menus for individual cells?
 

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors he

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike Monahan" wrote in message
...
Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

How do I create pull down menus for individual cells?
 

Conditional Formatting did the trick, and I saved the extended conditional
formatter for a rainy day, thanks for the helpful and prompt solution to my
problem!

"RagDyeR" wrote:

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors he

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike Monahan" wrote in message
...
Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

How do I create pull down menus for individual cells?
 

You're welcome, and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Mike Monahan" wrote in message
...
Conditional Formatting did the trick, and I saved the extended conditional
formatter for a rainy day, thanks for the helpful and prompt solution to my
problem!

"RagDyeR" wrote:

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors he

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike Monahan" wrote in message
...
Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy