Drop-down menu

[Marcel]

How do I create drop-down menu's in Excel to fill in cell values
consistently with same value.

thanks

marcel

 

[Debra Dalgleish]

You can use data validation to create a drop down list. There are
instructions in Excel's Help and here:

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