Using Data from a Separate Worksheet in a Drop Down List

If you enter the same data repeatedly into a worksheet using a drop down list can you save time and prevent data entry errors.

Excel gives you several options for choosing the source for the list items including choosing data located on another worksheet.

To find out how to do this, read this step by step tutorial on Creating a Drop Down List in Excel.

Other Data Management Tutorials

• Data Analysis using a Pivot Table in Excel
• Remove Duplicate Data Records in Excel
• Excel Data Entry Form Step by Step Tutorial