Drop down list

Hi Andrew

Thank you for your question regarding drop down lists.

The beat way to achieve this is to:

1. Create the source data for your drop down list somewhere on the spreadsheet, this must be on the same spreadsheet you want your list to appear.

2. Select the cell or highlight the range of cells you want the drop down list to appear in.

2. Select the 'Data' tab and click 'Data Validation'

3. On the 'Settings' tab, in the 'Allow' drop down list select 'List'.

4. Click into 'Source' text box and selct the data source from the spreadsheet (the items you want to have appear in the drop down menu.) and then click OK.

5. Selecting the cell will expose the drop down arrow.


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.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer