Table of Contents

    How to Create a Dropdown List in Excel: A Step-by-Step Guide


    Copy and Paste below data and practice it.

    Serial No Name Profession
    1 Raj
    2 Kumar
    3 Rekha
    4 Raju
    5 Puja
    6 Rahul
    7 Roky
    8 Adi
    9 Abhy
    10 Ramesh
    11 Kailash
    12 Ramu
    13 Romesh
    14 Rohit

    Professions

    Accountant
    Teacher
    Technician Laborer
    physical therapist
    Commercial Banker
    Engineer
    Lawyer

    Short Video: Example

    Create Gender dropdown for Male and Female