• About
  • Advertise
  • Privacy & Policy
  • Contact
  • Disclaimer
  • Latest
  • How To’s
  • ReviewNew
    Best SSD's for laptop

    Best SSD for Laptop – Budget, Mid-Range, High-Range

    One Plus 8

    OnePlus 8 : The Best Smartphone Ever?

  • GamingNew
    Tips to Optimize Gaming Experience on Mac

    Tips to Optimize Gaming Experience on Mac

    AMD

    AMD’s new Adrenalin Drivers delivers massive performance boost!

    Philips 288E2UAE

    Philips 288E2UAE: An affordable 4k 28″ monitor with a USB 3.2 hub

    What is Latency

    WHAT IS LATENCY? Explained

    AMD

    All that AMD announced at CES 2021

    ASUS ROG ZEPHYRUS

    Leaked! Asus ROG Zephyrus G15 GA503QS on Amazon

No Result
View All Result
  • Latest
  • How To’s
  • ReviewNew
    Best SSD's for laptop

    Best SSD for Laptop – Budget, Mid-Range, High-Range

    One Plus 8

    OnePlus 8 : The Best Smartphone Ever?

  • GamingNew
    Tips to Optimize Gaming Experience on Mac

    Tips to Optimize Gaming Experience on Mac

    AMD

    AMD’s new Adrenalin Drivers delivers massive performance boost!

    Philips 288E2UAE

    Philips 288E2UAE: An affordable 4k 28″ monitor with a USB 3.2 hub

    What is Latency

    WHAT IS LATENCY? Explained

    AMD

    All that AMD announced at CES 2021

    ASUS ROG ZEPHYRUS

    Leaked! Asus ROG Zephyrus G15 GA503QS on Amazon

No Result
View All Result
Unboxstop
No Result
View All Result

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

by Meenakshi Thakur
October 17, 2020
3 min read
Home How To's
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
Meenakshi Thakur

Meenakshi Thakur

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 *

Recommended.

What is a Drone

What is a Drone? or Unmanned Aerial Vehicle?

October 17, 2020
How to recharge Fastag

How to recharge Fastag?

September 16, 2020

Trending.

How to unprotect Excel sheet without password

How to unprotect Excel sheet without password?

October 25, 2020
IOT Architecture

What is IOT Architecture? Explained

February 17, 2021
Cyberpunk2077

Cyberpunk 2077 performance too low? Try EZ Optimizer 2.0

February 7, 2021
Top 5 Cloud Gaming Services

Top 5 Cloud Gaming Services

January 16, 2021
ASUS ROG ZEPHYRUS

Leaked! Asus ROG Zephyrus G15 GA503QS on Amazon

January 3, 2021

About Us

Unboxstop

Unboxstop is a one-stop platform for all the technology news around the world.

Follow Us

Categories

  • 3D Printing
  • 5G
  • Artificial Intelligence
  • Best
  • Blockchain
  • Drones New
  • Electric Cars
  • Featured
  • Gaming
  • How To's
  • IOT
  • Latest
  • Review
  • Virtual Reality

Tags

3D Printing 4K 5G augmented reality Best Big Data Bitcoin Blockchain CES 2021 Cloud Computing Cloud Gaming coronavirus Data Science Drones Electric Cars Gaming Hardware How To How To's Industry 4.0 Internet IOT Jet Engines Laptops Machine Learning News Productivity Review Robotics Solar Panels speech recognition Technology Trends Tesla Transport TVs Video virtual reality
  • About
  • Advertise
  • Privacy & Policy
  • Contact
  • Disclaimer

© 2020 UNBOXSTOP

No Result
View All Result
  • Latest
  • How To’s
  • Review
  • Gaming

© 2020 UNBOXSTOP

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