How to make a drop down list in excel for one cell
Select the cell in the worksheet where you want the drop-down list. Now is a good time to Sort your data in the order you want it to appear in your drop-down list. Why should you put your data in a table? When your data is in a table, then as you add or remove items from the list, any drop-downs you based on that table will automatically update. To stop people from entering data that isn’t in the drop-down list, click Stop. Information will show a message with this icon and Warning will show a message with this icon. To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, click Information or Warning. Not sure which option to pick in the Style box? If you don’t want a message to show up, clear the check box. If you want a message to pop up when someone enters something that's not in your list, check the Show error alert after invalid data is entered box, pick an option from the Style box, and type a title and message. If you want a message to pop up when the cell is clicked, check the Show input message when cell is selected box, and type a title and message in the boxes (up to 225 characters). If it’s OK for people to leave the cell empty, check the Ignore blank box.
Note that we left out the header row, because we don't want that to be a selection option: We put ours on a sheet called Cities, in range A2:A9. On the Settings tab, in the Allow box, click List.Ĭlick in the Source box, then select your list range. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again. Best of all, the temporary price drop brings the whole bundle down to only $39.Note: If you can’t click Data Validation, the worksheet might be protected or shared. The course contains $1,600 worth of training in one convenient package. Want to learn even more about Excel? The Excel Certification Bundle could be the perfect fit. As you can see, it wasn’t that hard but Microsoft makes things a bit more complicated by burying a lot of functions into its complex menu system.
HOW TO MAKE A DROP DOWN LIST IN EXCEL FOR ONE CELL HOW TO
Just hold the Shift key down while clicking.Īnd that’s it! Now you know how to create a drop down list in Excel. Simply select the rage of data input cells. You can now add the drop-down list into multiple cells. If you uncheck this it won’t present the actual drop-down list. You can also manually enter the cells, if you prefer (=$A$1:$A$4).Ĭheck the in-cell dropdown option. 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.