Creating a table in excel with drop down tabs

Hello Tashi,

Thank you for your question regarding how to create drop down lists in Excel.

The first thing that you need to do is establish what your drop down list will contain. You may already have a list somewhere that can be copied and pasted or you may wish to open a new worksheet and put your list into the first column. It is this list that you will use in a data validation method which will allow users to see from a drop down button when they click on a cell in a particular column. It is always a good idea to sort your list before using data validation.

Secondly, you now need to select all the cells in a column where you require the drop down list to appear...

Thirdly, take a look at the Data ribbon and locate the Data Validation button which you will find in the Data Tools group. Once you click the top half of this button you will open a dialogue box which contains three tabs. You will be using the Settings tab to create a drop down list.

Click the top drop down button where it says 'Any Value'
and select List. Click in the source box and click the button on the right. Navigate to where your list is kept and select the entire list. Click the button on the right again and then click OK. (If you don't have a list in the workbook then you can create the list in the source box separating each list item with a comma.)

Now click on a cell where you created the data validation. You will have a drop down button on the right side which when clicked will show you the list that was used for this purpose.

Give it a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer