All courses available in-class or via remote login

List of employee names in a spreadsheet

How to create a drop-down list in Excel

January 29, 2019

How to create a drop-down list in Excel

Drop-down lists are a great way to work as efficiently as possible with data entry in Excel. They allow you to easily select data items from an embedded list, which helps keep your data consistent, especially when a whole team is utilising it.

This short guide will show you how to make your own custom drop-down list in five easy steps.

Step 1

Open up a new Excel sheet, and enter the data options you want to have in your drop-down list. In this example, it’s a list of employees to choose from.

Step 2

On another Excel sheet, select the cell you’d like to fill with your drop-down list, in this case, B1.

How to create a drop-down list in Excel

Step 3

Now it’s time to fill B1 with your drop-down list data.

Go to the Data tab at the top of your sheet and click Data Validation.

How to create a drop-down list in Excel

Step 4

In the pop-up box, under Allow, select List.

How to create a drop-down list in Excel

Step 5

With the pop-up box still open, return to the sheet with your list of data, click in the Source box in the pop-up, and select all the employees in your sheet.

How to create a drop-down list in Excel

Click OK and voila! Your drop-down list of employees will appear in the B1 cell of your other sheet.

How to create a drop-down list in Excel

Are you looking to further your Excel skills? Check out our Excel Beginner, Intermediate & Advanced courses.

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 26985 Reviews
Good knowledge and very useful. -Excel Intermediate Remote Online
Liliana - Excel Intermediate, .
The instructions were clear and provided advice on pivot tables and graphs which found very helpful. -Excel Intermediate Remote Online
Dayle - Excel Intermediate, .
Very informative and easy to follow and understand. -Excel Intermediate Remote Online
Cindy - Excel Intermediate, .
Very well presented, Steven was very patient and explained things very well. was a very informative day. -Excel Intermediate Remote Online
Katherine - Excel Intermediate, .
Very informative course, well presented and I will use a lot of this information -Excel Intermediate Remote Online
Valerie - Excel Intermediate, .
Steven was a great teacher he was very patient and did everything step by step so it wasn't confusing. Would recommend this course to someone who is wanting to learn about excel. -Excel Intermediate Remote Online
Maddison - Excel Intermediate, .
Steven was very patient and went back to re-do steps if we got confused. Learnt a lot and was very informative. -Excel Intermediate Remote Online
Kim - Excel Intermediate, .
Very informative - expanded on my knowledge. Some good tips were provided regarding shortcuts. -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Very informative course! -Excel Intermediate Remote Online
Julie - Excel Intermediate, .
Steven was a great trainer -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Thanks a good fast paced course with a knowledgable trainer -Excel Intermediate Remote Online
Vicki - Excel Intermediate, .
Really informative course with Jason. Went at a good pace and constantly asked if we had any questions. -Excel Intermediate Brisbane
Roland - Excel Intermediate, .
Great session! Very informative. Ken was a great presenter, very patient and helpful. -Power BI Intermediate Melbourne
Donna - Power BI Intermediate, .
xlnt presenter -Excel Intermediate Brisbane
Neal - Excel Intermediate, .
Ken is a very good teacher and the whole training course is very informative and enjoyable. -Power BI Intermediate Melbourne
TUAN - Power BI Intermediate, .
Great day. Learnt a lot of new info about how to better use excel and save myself a lot of time trying to figure things out. Will reduce my workload! -Excel Intermediate Brisbane
Natalie - Excel Intermediate, .
Thought it was great! Very engaging considering completed remotely. Definitely helpful. Thank you! -Power BI Intermediate Melbourne
Lauren - Power BI Intermediate, .
Thank you for the course. Very clear and concise. I would definitely recommend the intermediate course for people with beginner experience. -Power BI Intermediate Melbourne
Matthew - Power BI Intermediate, .
Excellent course, a lot of information to take in over a day but very useful and feel confident enough to play around PBI on my own. Facilitator was very engaging and entertaining, so helped us stay tuned throughout the day. -Power BI Intermediate Melbourne
Iantha - Power BI Intermediate, .
Great pace, good examples and easy to follow. -Power BI Intermediate Melbourne
Tania - Power BI Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Nexacu offices Australia

Follow us