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.


Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions