There will be a dropdown arrow next to the cell that you selected. Make sure that each item is typed into the Source field while they are separated by commas. You can now type the items that you want in your list manually. Then just, select the dropdown list under Allow and select List. Ī Data Validation window will be opened.įrom the menu select Data and select Data Validation on the ribbon.Select the cells where you want the list to be created. But, you can only do this when you need a dropdown list in a single cell and it doesn't have to be updated frequently.įor instance, if you are sending someone an article where they have to fill out some fields, and there is a simple list of choices with one field, then this method could be found ideal. You can just enter the list manually in Excel and that would be the easiest way to create a drop-down list. But although it is pretty easy to create, you still have to know-how. You could want it to create surveys, web forms, and polls.Īs you can find the option to create a drop-down list in the Data Validation tool, it is actually pretty easy to make one in Excel. There could be various reasons for you to want a drop-down list depending on your situation. Excel has enormous potential and here we are going to find out how we could create a drop-down list in Excel. For office jobs, knowing everything about Microsoft Excel is probably the most important skill.
0 kommentar(er)
