Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. Part one covers creating a drop down list with data from the same worksheet. Part two covers creating a drop down list with data from a different worksheet. Both tutorials include step by step examples of how to create a drop down list in Excel 2007.
Creating a Drop Down List in Excel 2007 Part 1
Excel Drop Down List Tutorial
Creating a Drop Down List in Excel 2007 Part 1 covers the steps to creating a drop down list with data on the same sheet as the drop down list. The tutorial includes a step by step example of how to create a drop down list in Excel 2007.
Creating a Drop Down List in Excel 2007 Part 2
Excel Drop Down List Tutorial
Creating a Drop Down List in Excel 2007 Part 2 covers the steps to creating a drop down list with data from a different worksheet from the drop down list. The tutorial includes a step by step example of how to create a drop down list in Excel 2007.
