Skill Level Beginner
- [Chris] Have you ever filled out an online form that had drop-down list selections that made it easier to fill out? Like fields for items, size, color, or state and city. Did you know that you can easily set up the same kind of drop-down lists in Excel? My name's Chris Smith, but everyone calls me Smitty, and I write Excel help content for Microsoft. I've been using Excel since, let's just say I've been using Excel for while. And to me it's the best program there is, and I love sharing how to use it better. In this short course, we'll review the most common ways to build drop-down lists, from creating Excel tables that can automatically update your lists, to manually entering your list data.
We'll also show you how you can deliver meaningful input messages to guide people as well as spawn error messages if they try to enter values that don't meet your criteria. To wrap things up, we'll show you several examples of how to use drop-down lists in real world situations, such as where a list selection can look up data from other worksheets or how to use other tools in the drop-down list tool kit we call data validation to limit what people can enter, like the maximum number of hours in a time off request. In this course we'll be working entirely with a workbook called Drop-Down lists.xlsx, so let's get started.