![]() ![]() To delete or edit your dropdown list, click on the field it is in again, and click on Data and then Data validation at the top. Tip: If you put something other than the options in the list, you’ll see an error – the data validation option will inform you or your user that they’ve done something wrong even if you don’t set help text. When you are happy with your selection options, click the save button. ![]() Validation checks to make sure if the data in the field matches the requirements.ĭepending on your purposes, you can have the field reject unacceptable inputs, or even provide some help text that gives the users clues on what they should have put instead. This isn’t exclusive to dropdown lists and can be applied to any field. When you’re happy with that, you can add a few more functions. Alternatively, you can enter your own list items, separating them with commas. ![]() In the first case, you can select a range of fields in the format “Sheet1!A3:D3”. You have two main options to choose from – you can either create a list from an existing range of fields or enter the list items there. Then, click on the Data tab in your ribbon menu and select Data validation. Select the cell you want to add your list to. ![]() To do so, open the sheet you would like to create your dropdown list in. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |