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

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 - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.