Drop Down Menu Option

[silvertabb]

Hi,

I have a list of task say from 1 to 10 in column A. In column B I want to keep track of my task progress. I like to assign the following four for each task's status:

Not Done
In Progress
Done
Not Applicable

In Column B I like to be able to choose from the list. I know this is possible in ACCESS. Is this also possible in EXCEL?
thanks

 

[Cbrine]

1. Select Data....Validation from menu.
2. Set Allow: to list
3. Set Source to your values seperated by comma's
In your case it would be
Not Done,In Progress, Done, Not Applicable

4. Press OK.

You should now have a drop down combobox available when you select the cell.

HTH
Cal

 

[Norie]

Select column B, or the range in column B you want the dropdown in.

Select Data>Validation.

Select List for the Allow value and enter this

Not Done,In Progress,Done,Not Applicable