Create Drop Down List in Excel Worksheet Cell
http://www.contextures.com/xlDataVal0... In an Excel worksheet, you can create a drop down list in a cell, or group of cells.
Instead of typing, people select from that drop down list, to prevent typing mistakes and invalid entries.
Watch this video to see how to name a list, and then create drop down lists in the worksheet cells, based on that list.
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
Save Time with the Excel Data Entry Pop Up Kit: http://www.contextures.com/datavalida...