How to Create a Drop Down List in Excel (with Pictures) - wikiHow

The 5 steps to create a drop-down in 1 minute or less. A drop down list is actually a tiny window from where you can peek into some other data you have constructed.

This also gives you the possibility of controlling exactly what can be entered into a cell. This makes the drop-down menu a very common and powerful data validation tool.

Follow along by downloading our sample file right below! In the pop-up box, you need to click the drop-down menu to pick what kind of data validation method you want to use how meta is that?! Want to speed up this process even more?

With some practice, you can almost create these drop-downs instantly. Sign up right below and get access to 3 action-packed lessons.

We just released 7 new courses, instantly available to you upon creating a membership. We hate spam as much as you.

How to Create a Drop-Down in Excel in 1 Minute (or less)

Your email is safe with us. The 1 Minute Drop-Down: How To Easily Create A Drop-Down List in 60 seconds or less The 1 Minute Drop-Down: How To Easily Create A Drop-Down List in 60 seconds or less.

Create a drop-down list - Office Support

In the animation right below you can see the drop-down menu in action. Behold its mighty glory! First we have a sheet with all the names of our employees.

This is the data we would like to see when opening our drop-down menu. GET FREE INSTANT ACCESS. Contact us Wanna get in contact?

How-To Add Drop-Down Lists And Data Validation To Excel Spreadsheets

Feel free to write us at: Training and Courses Membership login Free Excel Training Blog About. Our very best content We publish a lot of awesome content about Microsoft Excel.

Here's our top picks: Free Training for Excel The last guide to VLOOKUP you'll ever need The ultimate guide to Pivot Tables We just released 7 new courses, instantly available to you upon creating a membership.

I already know everything about Excel. Enter your email below and get instant access to our free Excel training.

Where would you like us to send your free Excel training? Send this to friend Your email Recipient email Send Cancel.