![]() Enter a Title and an Input message and then click the “OK” button. Make sure the “Show input message when the cell is selected” box is checked. To do this, click the “Input Message” tab on the Data Validation dialog box. You can add a popup message that displays when the cell containing the drop-down list is selected. If you want to require the user to select an option from the drop-down list, uncheck the Ignore blank check box. This means that the user can select the cell and then deselect the cell without selecting an item. ![]() The “Ignore blank” check box is checked by default. ![]() Make sure the “In-cell dropdown” box is checked. Enter =Age in the “Source” box (if you named your cell range something else, replace “Age” with that name). Now, we’re going to use the name we assigned to the range of cells containing the options for our drop-down list. On the Settings tab, select “List” from the Allow drop-down list (see, drop-down lists are everywhere!). In the Data Tools section of the Data tab, click the “Data Validation” button. Now, select the cell into which you want to add a drop-down list and click the “Data” tab.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |