Excel Drop Down List Tutorials

These tutorials cover creating a drop down list in Excel for both data entry and for data validation. Long and short versions of the tutorials for creating a drop down list from a) data located on the same worksheet and b) data located on a different worksheet are available. Step by step examples are included with each tutorial.

Excel Drop Down List Step by Step Tutorial
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel.

Excel Drop Down List Pt 2 - Using Data From a Different Worksheet
A second option for a drop down list is to store the list data a separate worksheet. This can help protect the list from accidental changes.

Excel Drop Down List Pt 3 - Using Data From a Different Workbook
A third option for a drop down list is to store the list data in a separate workbook. This can be useful if the same list is used in more than one workbook and and by more than one person.

How to Remove a Drop Down List
If you no longer need a drop down list, this tutorial covers how to remove it and other data validation options from an Excel worksheet.

Excel Drop Down List Quick Tutorial Pt 1
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel.

Excel Drop Down List Quick Tutorial Pt 2
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel with data located on a different worksheet.

Discuss in my forum

Spreadsheets