How to add drop down list box in Excel

To add drop down list box in Excel, proceed with the following steps:

1. Click, Data > Data Validation > Data Validation

2. Select List from Allow drop down list box under Validation Criteria.

Adding drop down list box in Excel 2003

3. You can either provide source list from existing sheet, or columns, or can feed values directly in this dialog box. Follow any of the following steps to bind values in drop down list box.

a. Providing values for the drop down list box from same sheet

i. Type desired values to be placed in the drop down list box in the same sheet anywhere

Data for displaying in drop down list box

Type the desired values anywhere in the excel sheet to display in the drop down list box.

ii. Select source icon to map the data

 

Select the source to display in drop down list box

Select the source to display in drop down list box

iii. Select the cells where the data values are present in the same excel sheet

Select the source to display in drop down list box

Select the source to display in drop down list box

Select the data values present in the same excel sheet

Select the data values present in the same excel sheet

iv. Select “Ignore Blank’ checkbox to ignore the blank values if the user does not select any values from the drop down list box. Click OK after selecting source data values.

Click OK after selecting the source

Click OK after selecting the source

v. Now the drop down list box will be placed in the selected cell.

Drop down list box in excel sheet 2003

Drop down list box in excel sheet 2003

b. Specify data values in the dialog box directly

Type data values in source directly

Type data values in source directly

Share This Post

Related Articles

Leave a Reply

© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups