Predictive Hacks

How to Create Drop-Down Lists in Excel

Data entry is quicker and more accurate when you use a drop-down list to limit the entries that people can make in a cell. Let’s see how we can create a Drop-Down Lists in Excel. Let’s assume that we have the employees’ ID and we want to add the department in a drop-down list. The Departments are Product, Sales, Finance and Other.

A) Select the cells that you want to contain the lists:

B) On the ribbon, click the DATA tab, and click Data Validation

C) In the dialog, set Allow to List and Click in Source. In this example, we are using a comma-delimited list. The text or numbers we type in the Source field are separated by commas. Click OK and the cells will have a drop-down list.

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore


Image Captioning with HuggingFace

Image captioning with AI is a fascinating application of artificial intelligence (AI) that involves generating textual descriptions for images automatically.


Intro to Chatbots with HuggingFace

In this tutorial, we will show you how to use the Transformers library from HuggingFace to build chatbot pipelines. Let’s