Microsoft Weekly Newsletter Be your company's Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets. Delivered Mondays and Wednesdays Sign up today. Editor's Picks. It's time to dump Chrome as your default browser on Android. Women and middle managers will lead the Great Resignation into How Windows 11 makes updates so much smaller. Linux finally has an impressive cloud-like OS in Ubuntu Web.
Best Raspberry Pi accessories and alternatives for Show Comments. One of the most useful features of data validation is the ability to create a dropdown list that let users select a value from a predefined list. Dropdown lists make it easy for users to enter only data that meets your requirements. Dropdown lists are easy to create and use.
But once you start to use dropdown menus to your spreadsheets, you'll inevitably run into a challenge: how can you make the values in one dropdown list depend on the values in another?
In other words, how can you make a dropdown list dynamic? These kind of lists are called dependent dropdowns , since the list depends on another value.
In the example shown below, column B provides a dropdown menu for food Category, and column C provides options in the chosen category. If the user selects "Fruit", they see a list of fruits, if they select "Nut", they see a list of nuts, and if they select "Vegetable", they see a list of vegetables. Any entries that are edited are effective immediately, so all drop down lists will now use the new values.
Select the Name Manager icon to display the Name Manager dialog. Select your list name and check that the cell range is correct. One last thing. If you have been handed a spreadsheet, you can apply validation to existing data. The data may be good, bad or mixed. Set up the drop down lists using the data validation tool as described above.
If you want to delete your drop-down list, see Remove a drop-down list. To see a video about how to work with drop-down lists, see Create and manage drop-down lists. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. For example, check to see how to Change the column width and row height to show your updated entries. In Excel for the web, you can only edit a drop-down list where the source data has been entered manually.
On the Settings tab, click in the Source box. Then do one of the following:. If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. When you're done, each entry should be separated by a comma, with no spaces. For example: Fruits,Vegetables,Meat,Deli. In this example, you'd add or remove entries in cells A2 through A5. If the list of entries ends up being longer or shorter than the original range, go back to the Settings tab and delete what's in the Source box.
Then click and drag to select the new range containing the entries. If the Source box contains a named range, like Departments, then you need to change the range itself using a desktop version of Excel. You can always ask an expert in the Excel Tech Community or get support in the Answers community.
Create a drop-down list. Apply Data Validation to cells. Video: Create and manage drop-down lists.
0コメント