Excel Data Validation List from another Worksheet

By Ted French, About.com Guide

Starting the Drop Down List

All data validation options in Excel, including drop down lists, are set using the data validation dialog box.

The data validation dialog box is located under the data tab of the ribbon.

Tutorial Steps

1. Click on the Sheet 1 tab at the bottom of the screen to switch to sheet 1


2. Click on cell E1 to make it the active cell - this is where the drop down list will be located


3. Click on the Data tab of the ribbon menu above the worksheet


4. Click on the Data Validation icon on the ribbon to open the drop down menu


5. Click on the Data Validation option in the menu to open the Data Validation dialog box

Previous

• Using data from another Worksheet in the Data Validation List
• Entering the Tutorial Data
• Creating a Named Range for the List Data
• Opening the Data Validation Dialog Box
• Using a List for Data Validation
• Entering the Data Source and Completing the Drop Down List
• Editing the List Items
• Options for Protecting the Drop Down List

Next