How can we help you today?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Welcome to 'Sikkhon' User Forum

Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users. You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.

Create a drop-down list in Excel - Data Validation

Posted 7 months ago by Alamin Amin Hossain

Un Answered
Alamin Amin Hossain

MS Excel Drop-down lists are helpful if you want to allow people to select an item from a list, instead of typing their own values.


Drop-down lists are one way to simplify data input. also, dropdowns can make data entry faster, more accurate and more consistent. 

Microsoft Excel is good at organizing and analyzing complex data. One of its most useful features is the ability to create dropdown menus, which allow users to select an item from a predefined list.


Before you insert the drop-down list you need to type the items you want to appear in the drop-down list. This is what we call the ‘list items'



It can be in the same sheet or another sheet. we will discuss both in that post. lets see in the same sheet first.


Go to the Data tab on the Ribbon, and then Data Validation


Now, a dialog box  appears ‘Data validation’ . Here, you choose the settings for your drop-down list.



in the Settings tab, click the list in allow drop-down list. 


Now, connect that list of options with the drop-down menu. click in the ‘Source:’ box in the setting


Select in the Source box, then select the cells containing your drop-down list items. This can be done in the same worksheet as the dropdown list or in a different sheet.



You can choose  your drop-down list items from separate sheet. then click your sheet first. then select the range.

 

After setup click ‘OK’.


You have successfully created a simple dropdown list in Excel. Now, your users can click an arrow next to a cell, and then select the entry they want.


Thanks.




Attachments (1)

0 Votes


0 Comments

Login or Sign up to post a comment