• About us
  • Contact us
  • Disclaimer
  • Home
  • Home 1
  • Home 2
  • Home 3
  • Home 4
  • Home 5
  • Latest
  • Privacy Policy
Unboxstop
No Result
View All Result
No Result
View All Result
Unboxstop
No Result
View All Result
Home How To's

How to create a drop down list in excel? Simple Steps

Meenakshi Thakur by Meenakshi Thakur
October 17, 2020
in How To's
0
How to add a drop down list in excel
481
SHARES
1.6k
VIEWS
Share on FacebookShare on Twitter

How to create a drop down list in excel is the most asked question by people who keep their database in an excel sheet. The drop-down list in an excel sheet helps us to navigate through different items/values and select one of them without having to add it in the sheet manually across different cells. 

How to create a drop down list in excel? Step by Step

It’s definitely not difficult to add a drop-down summary to a cell in an excel, yet the technique isn’t regular. Drop-down records are made using the Data Validation feature. We will make a drop-down list with the name of animals and make sure that you understand the process step by step.

  • To begin, enter the name of the animals consecutively in one cell. Here we have entered the names of the animals in the drop-down, which can be understood from the figure. In the same manner, you can add your desired data in the cells. For example, cell numbers 3 to 9 contain the names of various animals.

How to add a drop down list in excel

 

  •  Drag the cell from Cat to Parrot and type it ‘Animals’ in the Name Box section

How to add a drop down list in excel

 

  • Now, select the cell into which you have to add a drop-down list (we have selected ‘Cat’) and click on the “Data” tab next to the Formulas.

  • The Data Validation dialogue box will now appear. On the Settings tab, select “List” from the allow drop-down list. In the Data Tools section of the Data tab, click the “Data Validation” button.

  • Now, we’re going to use the name we assigned to the range of cells containing the options for our drop-down list. Enter =Animals in the “Source” box (if you named your cell range something else, replace “Animals” with that name).The “Ignore blank” checkbox is checked by default. Make sure the “In-cell dropdown” box is checked.

  • You can add a popup message that shows when the cell containing the drop-down overview is picked. To do this, click the “Input Message” tab on the Data Validation dialogue box. Make sure the “Show input message when the cell is selected” box is checked. Enter a Title and an Input message and a short time later click the “ok” button.

How to add drop down list in excel

 

  • When the cell containing the drop-down list is selected, you’ll see a down arrow button to the right of the cell. If you added an input message, it displays below the cell. The down arrow button will only showcase when the cell is selected.

How to add a drop down list in excel

  • Click the down arrow button to drop down the list of options and choose your choice.

  • If you decide to remove the drop-down summary from the cell, open the Data Validation trade box as portrayed previously and snap the “Clear All” button, which is available no matter which tab is selected on the dialogue box. The choices on the Data Validation trade box are reset to their defaults. Click “ok” to clear the drop-down and restore the cell to its default structure.

If you follow these steps, you can very easily create drop-down in excel. There are many other ways in which you can perform this task, but this way remains the simplest.

 

Tags: How To'sProductivity
Previous Post

What is Data Science? Beginners Guide

Next Post

How to Download Google Play Store for PC

Next Post
how to download google playstore for pc

How to Download Google Play Store for PC

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • About us
  • Contact us
  • Disclaimer
  • Home
  • Home 1
  • Home 2
  • Home 3
  • Home 4
  • Home 5
  • Latest
  • Privacy Policy

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • About us
  • Contact us
  • Disclaimer
  • Home
  • Home 1
  • Home 2
  • Home 3
  • Home 4
  • Home 5
  • Latest
  • Privacy Policy

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.

Welcome Back!

Login to your account below

Forgotten Password?

Create New Account!

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In

Add New Playlist