microsoft excel training class - Applying a drop down option

Hi Dinesh

Thanks for your question.

You can use Data - Validation, then choose List from the Allow: box.

Under Source: type in each item that you want to have in your dropdown list with a comma between each item, e.g. Sales, Accounts, Human resources, Administration.

Then click OK.

I hope this helps.
Amanda