Try Data Validation:

Select ALL of the Project Status input cells
<data<validation
Allow: List
Source: Completed,On Track,Postponed,Behind
Click the [OK] button

Now, those cells will only allow the listed items.

For more information on Data Validation, see Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Maryjerk" wrote:

I need for each cell in a particular column, to populate ONLY with the
choices given in a scroll down menu for each cell in that column. The column
is entitled "Project Status" and the only word choices that should populate
this cell, which are to be chosen from a scroll down menu, a Completed, On
Track, Postponed, Behind.

Thanks for your help. mj