Okebiz Video Search



Title:How to Create Drop Down Lists in Cells - The Complete Excel Guide
Duration:12:48
Viewed:1,225,949
Published:13-08-2018
Source:Youtube

In this video you will learn how to create drop down lists in cells in Excel. These are also referred to as Data Validation Lists. The drop down lists allow the user to select from a drop-down menu of items and input the value in the cell. Download the practice Excel file: https://www.excelcampus.com/tips/data...

Drop-down lists in cells are great for data entry or inputs for interactive financial models.

I explain how to:
- Create the drop down list from a comma separated list.
- Create the drop down list from a range of cells.
- Use keyboard shortcuts to select items from the list.
- Copy or apply the drop down lists to other cells.
- Handle errors and invalid inputs.
- Add new data to the source range and update the list.

Compatibility: Data validation drop-down lists are available in all versions of Excel including Excel 2003, 2007, 2010, 2016, 2019, Office 365 for Windows and Excel 2011, 2016, and beyond for Mac.

The Free List Search Add-in:
Unfortunately we can't directly search the drop down lists within Excel. So I created a free add-in called List Search that allows you to search any drop down list and input the value in the cell.

It's packed with additional time saving features. Click the link below to learn more and download List Search.

Download The List Search Add-in: https://www.excelcampus.com/vba/searc...

Other Videos and Resources:

- How to create Dynamic drop-down lists: https://youtu.be/RLLdY37YUgs
- How to search drop-down lists: https://youtu.be/kntHn2J7pdk
- Update to List Search Add-in: https://youtu.be/igPO79uYoGg
- Dependent Cascading Drop Down Lists: https://www.excelcampus.com/tables/de...

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
How To | Create Dependent Drop-down Lists in Excel How To | Create Dependent Drop-down Lists in Excel
15:29 | 426,374
Excel 2016 Advanced Excel 2016 Advanced
38:45 | 766,615
Creating Easy Data Entry Forms in Excel Creating Easy Data Entry Forms in Excel
09:52 | 650,134
Using Checkboxes in Excel - Part 1 Using Checkboxes in Excel - Part 1
10:10 | 304,129
VLOOKUP Tutorial for Excel - Everything You Need To Know VLOOKUP Tutorial for Excel - Everything You Nee...
21:50 | 21,933
Microsoft Excel Tutorial for Beginners - Full Course Microsoft Excel Tutorial for Beginners - Full C...
26:10 | 354,246
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row) Create Multiple Dependent Drop-Down Lists in Ex...
11:57 | 547,078
How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup in Excel How to Auto-Populate Fields in Excel Using a Dr...
09:55 | 317,863


coinpayu