Lists

Hello Rob

Thank you for your question and welcome to the forum.

You can create dropdown lists in Excel using a feature called data validation (Data menu - Validation option).

Firstly, select the cell/s you wish to have the dropdown list available in.

Then on the Settings tab, select List and then in the Source box, type each item separated by a comma and a space, e.g.
Sales, Marketing, Accounts

You can create further settings for the validation using the Input Error and Error Alert tabs if you wish, and then click OK.

Your dropdown list should appear on the cells you selected before setting up the validation.

Data validation and other useful topics are covered as part of our Excel Advanced course. Further information about the course including syllabus and dates can be found on the following page:
https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php

Amanda