Solved: Drop-down for each cell under a column

[arrun]

Hello, In my excel-sheet, there is a column named "work status". Entry under this column will be either "in progress" or "Complete". Here I want to create Drop-down kind of thing for each cell (under that column), where elements will be "in progress" and "Complete". User will select the item from that Drop-down, instead of manual-typing.

Any suggestion on how to do that?

Regards,

[Aussiebear]

Use data validation. Create a named range (called Work-Status) with the choices you only want. Store this named range in an out of the way location in your workbook.
Select the first cell where you want this to appear, select Data,Validation, List, and type in =Work_Status. Click OK, then grab the fill handle and drag down to the end of the column

[RonMcK]

It might be easier to highlight the range of cells (column on worksheet for Work Status for length that you are going to use), select Data > Validation (as Aussiebear mentioned), then select "List" (Allow dropl list) and in the Source: field that becomes visible type your entries "in progress, complete", and click OK.

If the future, when you want to add a value, open the first data cell in the column with Data > Validation, add the additional status(es) in Sources, click the check box for "Apply these changes to all other cells with the same settings", then, click OK. Excel does the heavy lifting.

Cheers,

[Aussiebear]

There you go ... two methods.

[arrun]

Thank you so much for your kind help

[RonMcK]

If you now have a solution, please mark your thread 'Solved'.

Thanks,