Click the Data tab and select Data Validation in the Data Tools group. A Data Validation dialog box will appear. Under Allow, click the drop-down arrow and select List from the drop-down list.

You can select a different worksheet so the source list will not be visible. Click the "Data" tab on the command ribbon and click "Data Validation" in the Data Tools group to open the dialog box.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

On the Data Validation dialog, choose the criteria you want to use in the boxes on the Settings tab. Go to the Input Message tab and enter the message you want users to see when they click in the ...

In the Data Validation dialog box, select List from the Allow drop-down menu. In the Source field, enter the values you want to appear in the drop-down list, separated by commas, or select a range ...

Figure A We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.