Now when you try to type something different in the list, you get the error message you created.Concatenates multiple text strings into a single string. You need to select the Show Error Message checkbox, select an error type (Stop is what you want to enforce selection of an item from the list), and optionally type the error title and error content.ġ1. (You didn't have to click OK at that point I just had you do that to show you the effect of not setting an error alert.) Select the cell where the dropdown list is and choose Data > Validity again.ĩ. If you want to require that people only enter something from the list, you need to do one more step. However, note that you can still type something that's not in the list, in addition to selecting something in the list.ħ. Just press Enter to get to each new line.Ħ. If you don't mark this, the items appear in the order you entered them.ĥ. Sort entries ascending: alphabetical order sorting. (To modify an existing list, just select it and choose Data > Validity again.) What's the point of a list if you don't see it? Plus, then it's hard to figure out which cell has the list, to go back and modify it. Show selection list: you definitely want this. This means you don't have to select a value from the list, but if you type even one blank space, you can get the error message. Allow blank cells: just what it sounds like.
In the list at the top, choose List as the type of information.
Click in the cell where you want the list.ģ. So how do you make this list? I'll tell you.ġ. Sucks in the text in the dropdown list in B2. =CONCATENATE(B2 " is an excellent source of information.") Click the following illustration to see it larger. In the following illustration, the value in B2, selected from a dropdown list, is referenceable in another cell.Īnother way you can use the values in the dropdown list (among many) is to concatenate them. The lists are easy to make, plus you can easily use the values in formulas. The simplest way is to use the tools accessed under Data > Validity. You can make dropdown lists in a couple ways, at least, in. They help you control what people can enter, as well as giving them ideas for what types of things they might say. Dropdown lists are a mainstay of many spreadsheets and forms.
0 kommentar(er)
