Next, click Source control and you can then drag and highlight the cells you filled with your list in step 1. Next you’ll go up to the menu and click Data > Data Validation.ģ. Of course where you put things is pretty flexible, such as if you want to use A1 through D1, or even if you want to put the list’s data into a different sheet in the project.Ģ. In this example we used cells A1 through A4. While the individual steps may vary depending on what version of Excel you’re using, the general process remains about the same. A list of the items that will go into your drop down.To make a drop down list you’ll need two elements: Related: Here’s how to merge cells in Excel Unfortunately, it’s pretty hard to find - even if it’s easy to do once you have the know-how. Making a drop down list in Excel is actually pretty simple, as the option can be found in the Data Validation tool. Why would you want a drop down list? While the answer to that will depend on your situation, drop down lists are particularly helpful for creating surveys, polls, and web forms. Today we’re going to discuss how to create a drop down list in Excel. Mastering this ubiquitous tool is like having the ultimate transferable skill on your resume. When it comes to office jobs, few skills are as beneficial as Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |