1 Comment

  • Great article, Ann! Your tips on using data validation for drop-down lists are super helpful, especially for cutting down on typos. Have you covered how to link these lists across multiple sheets yet? Thanks for making Excel less daunting!

  • Leave a Reply

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

    Make a Drop-Down List in Excel

    Last updated

    Sep 2nd, 2025

    Related resources:

    , , , ,
    thumbnail

    Are you typing data directly into Excel?

    (Rather than exporting it from a database?)

    If so, drop-down lists can save time and reduce typos.

    Here’s how to make them in Excel with a feature called Data Validation:

    More about Ann K. Emery
    Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

    1 Comment

  • Great article, Ann! Your tips on using data validation for drop-down lists are super helpful, especially for cutting down on typos. Have you covered how to link these lists across multiple sheets yet? Thanks for making Excel less daunting!

  • Leave a Reply

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

    You Might Like

    Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

    Enroll

    Maps as Icons

    Quick wins for improving boring, black and white tables with everyday software like Excel and PowerPoint.

    More »

    Need some time-savers in Excel? Feel like all the formulas are taking forever? Learn how to clean, analyze, and tabulate your dataset.

    Enroll

    Spreadsheets to Stories
    Weekly Newsletter

    You’ll receive:
  • how-to tutorials about data management, analysis, visualization, and storytelling;
  • spreadsheets to download so you can try it yourself; and
  • the latest info about our online courses.

    Our weekly newsletter is shared with a community of 8,000 professionals.