Adding a Drop-Down List to Excel

In my Productivity Tips webinars with Tom Duff (@duffbert), we often share tips that come from others within the community, and I always love giving shout-outs to those folks. This is a great tip mentioned in a TechRepublic article (check it out) that I came across while looking for instructions on how to accomplish this — and I thought I’d share. I included in in the October 2019 Productivity Tips webinar, which you can find on the blog, on the CollabTalk YouTube page, or jump to the video tip by clicking here.

Why would you want to add a drop-down list to an Excel spreadsheet, and not just create a form or a Power App? Well, you could do that if it better meets your needs — but sometimes you want something quick and easy within the app you’re working with, and then simply share out a link or, if it’s within one of the latest versions of Office, do some co-editing. Sometimes you may want to send out a spreadsheet for your users to fill out, or maybe you find yourself tracking repetitive data and want an easier way to collect information on your own. Whatever the use case, this is a quick tip for generating drop-down lists to make that data entry just a little bit easier.

Check out this productivity tip over on TekkiGurus!

Christian Buckley

Christian is a Microsoft Regional Director and M365 Apps & Services MVP, and an award-winning product marketer and technology evangelist, based in Silicon Slopes (Lehi), Utah. He sits on the board of TekkiGurus, is an advisor for both revealit.TV and WellnessWits, and provides channel and marketing services for Microsoft partners. He hosts the quarterly #CollabTalk TweetJam, the weekly #CollabTalk Podcast, and the Microsoft 365 Ask-Me-Anything (#M365AMA) series.

1 Response

  1. March 1, 2020

    […] Adding a Drop-Down List to Excel [buckleyPLANET] […]