Drop down menus

Hi Sana,

Thank you for the forum question.

Dropdown menus are created by setup up data validation.

You can type the list or you can use a range in which you have the options you want on you dropdown.

1 select the cell or range where you want to use the list.
2 Go to the Data tab on the ribbon. Click Data Validation in the Data Tools group.

3 In the Data Validation dialog box select List from the Allow list.
4 Click inside the Source: box.
5 Type the option separated by a comma (January,February,March) or select a range in you sheet with the option you want to select from the dropdown.
6 Click OK

I hope this can help you to create dropdown menus.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector