add a drop down in excel sheet

how to add a drop down in excel sheet

We can add the drop-down list in excel files. The given below steps and video might help you.

Table of Contents

Step1. Open excel sheet.
Step2. Type items for display in drop-down.
Step3. Select area where u want to display drop-down.
Step4. Go to the data tab.
Step5. Select the data validation tab and click on it.
Step6. Select the setting tab in data validation.
Step7. Allow the list validation criteria.
Step8. Add the source of typed items Step1.


Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog -
My Books - Book 1 and Book 2 Powered by Blogger.