How to create Drop-Down box in Excel

If you want to user select item from your list instead of other value you can create drop-down box in sheet. Please follow below mention steps.

Create list of items which you want to appear in the box as mention below.

Select Column where you want to create Drop down Box and Open Data Validation from Data Tab ( Data -->Data Validation ), In data Validation click Setting Tab Please select “List”

Click on Source and select List which you have created earlier as mentioned below.

Click On "OK" button and you have created a Drop-Down Box as mention below.

Also you can hide column where you have created List