• Home
  • About
    • About Us
    • Our Team
    • Become an Instructor
    • Donate
    • Help
    • Terms of Service
  • Courses
    • Academic Writing
    • Data Analysis
    • Free Courses
    • Information Technology
    • Islamic Finance
    • Programming Language
  • Blog
    • Biography
    • Healthy Life
    • Islamic Finance
  • Contact
Have any questions?
+233 26 765 7171
+233 50 728 3958
Login
The Call eAcademy
  • Home
  • About
    • About Us
    • Our Team
    • Become an Instructor
    • Donate
    • Help
    • Terms of Service
  • Courses
    • Academic Writing
    • Data Analysis
    • Free Courses
    • Information Technology
    • Islamic Finance
    • Programming Language
  • Blog
    • Biography
    • Healthy Life
    • Islamic Finance
  • Contact

    1.1 Creating a Drop-down List

    • Home
    • 1.1 Creating a Drop-down List

    1.1 Creating a Drop-down List

    • Posted by The Call Info
    • Date October 17, 2021
    [featured_image]
    Download
    Download is available until [expire_date]
    • Version
    • Download 0
    • File Size 4.00 KB
    • File Count 1
    • Create Date October 17, 2021
    • Last Updated October 17, 2021

    1.1 Creating a Drop-down List

    Overview

    Data Validation in Excel lets you control the data that can be entered in a cell. You can restrict the user to enter only a specified range of numbers or text or date.

    Data validation is a feature in Excel used to control what a user can enter into a cell. If data isn’t accurate from the start, your results definitely won’t be accurate either. That’s why it’s necessary to verify and validate data before it is used.

    Using validation rules to cleanse data ensures the integrity of data before use which goes a long way to ensure the legitimacy of your conclusions.

    Validating the accuracy, clarity, and details of data is necessary to mitigate any project defects. Without validating data, you run the risk of basing decisions on data with imperfections that are not accurately representative of the situation at hand.

    The focus of this lesson is to ensure that you can use data validation to restrict the type of data or values you enter in a cell during data entry.h There are three situations where you would want to use Data Validation in Excel:

    • When you want to restrict data entry to certain numbers/text/dates. Data that does not meet the validation criteria is not allowed.
    • When you want to inform user whenever out-of-range data is entered. However, all kinds of data entry is allowed.
    • When you guide the user on what data to enter. All kinds of data entries are allowed.

     

    A drop-down list is an excellent way to give the user an option to select from a pre-defined list.

    https://thecalleacademy.thecallinfo.com/wp-content/uploads/2021/09/3137b18f-1433-4486-a897-033e55c7_1500.mp4

    Fig 1: A video on overview of data validation. Source: Microsoft Support

     

    Learning Outcomes

    By the time you complete this lesson, you should be able to:

    • to create a data validation rule that picks data from the drop-down list
    • create a drop-down list by using Data from Cells
    • create a drop-down list by entering Data Manually

     

    Using Data Cells to Create a Drop-down List

    The video in figure 2 demonstrate how you can create a drop-down list from a range of cells.

    Sheet 1 and Sheet 2  are being renamed as Validation Table and Faculty List respectively in figure 2. It's a common practice to type repeatedly some entries (male, regular, religion) when you do entries for gender, status, and faculty.

    This tutorial will walk you through anexcellent option to select from a pre-defined lists instead of having to type such entries for each record.

     

    Fig 2: A sample table

     

    1. Type the entries (list of faculties) you want to appear in your drop-down list. Ideally, you’ll have your list items in an existing Excel table.

    2. Select the cell (faculty) in the table where you want the drop-down list.

    3. Go to the Data tab ribbon.

    4. Click Data Validation.

    5. Click List in the Allow box of the Settings tab.

    6. Click in the Source box.

    7. Select your list range. We have our list in range C1:C4.

    8. Check the Ignore blank box if you think it’s OK for users to leave the cell empty.

    9. Check the In-cell drop-down box.

    10. Click OK.

     

    https://thecalleacademy.thecallinfo.com/wp-content/uploads/2021/09/Vacelldrop-1.m4v

    Fig 2: Using cell range to create dropdown list

     

     

    Fig 2: Drop-down list from data cells

     

     

    Using Data Manually to Create a Drop-down List

     

    Fig 3: Drop-down list from manual data

    • Share:
    author avatar
    The Call Info

    information Technology

    Dr. Adam Mahama is the founder of The Call eAcademy.

    EDUCATION: Faculty of Science, University of Ibadan, Nigeria; Institute of Languages, King Saud University, Riyadh, Saudi Arabia; College of Science, King Saud University, Riyadh, Saudi Arabia; University of Cape Coast, Cape Coast, Ghana; College of Science and Engineering, Atlantic International University, Honolulu, US.

    QUALIFICATION: Diploma Arabic Language; Bachelor of Science (Statistics); Postgraduate Diploma in Education (Mathematics); Master of Education (Information Technology); Doctor of Science (Information Technology).

    EXPERIENCE: Resource person/examiner/instructor - Islamic University College, Ghana; IUG Journal of Humanities and Social Sciences (editor); West African Examinations Council; National Vocational and Technical Institute; Ghana-Lebanon Cooperation & Training Centre; Agricultural and Rural Development; Japan Motors Co. Ltd; F. Malawi Engineering Co. Ltd; and Ghana Supply Commission.

    You may also like

    IMG_20190720_071829_692-1024×831
    Shaikh Al Rajhi
    18 July, 2021
    papaya
    Benefits of Papaya Seeds
    11 June, 2021
    1024x576_bonus-Faridarl-696×392
    Disability Doesn’t Mean Disadvantage
    15 May, 2021

    Latest Courses

    Introduction to Computing

    Introduction to Computing

    $ 50.00 Free
    Computer Exams

    Computer Exams

    Free
    Protected: Data Analysis with Excel – 1 –

    Protected: Data Analysis with Excel – 1 –

    Free

    Categories

    • Biography
    • Blog
    • Business
    • Design / Branding
    • Healthy Life
    • Islamic Finance
    • Uncategorized

    Company

    • About Us
    • Blog
    • Contact
    • Become an Instructor

    Links

    • Courses
    • Donate
    • Events
    • Gallery
    • Help

    Support

    • Documentation
    • Forums
    • Language Packs
    • Release Status

    Recommend

    • WordPress
    • LearnPress
    • WooCommerce
    • bbPress

    © 2022 The Call Info. All Rights Reserved. Powered by WordPress.

    • Privacy
    • Terms
    • Sitemap
    • Purchase

    Become an instructor?

    Do you already have a skill, or expertise that you can earn money hassle free from and also make a massive impact on the experience of other learners?

    Get Started Now

    Login with your site account

    Lost your password?

    Whatsapp Call Now
    Please enter your phone number and we will call you back soon

    Thank you

    We will call you back soon

    Please enter valid phone number