![]() ![]() The drop-down button appears on the right side of the cell. Type Internal, External in the Source: box that appears.įor the selected first cell under Risk Source −Ĭlick in the cell for which you have set Data Validation criteria.Under Validation criteria, in the Allow: drop-down list, select the option List.Click Data Validation in the Data Tools group.Click in the first cell under the column Risk Source (I6).In this case, we have only two values – Internal and External. Hold on the + symbol that appears and pull it down.ĭata Validation is set for all the selected cells.Ĭlick the last column that is selected and verify.ĭata Validation for the column Risk Category is complete.You can easily do this by clicking on the right-bottom corner of the first cell.Set the validation criteria for 10 cells under Risk Category.If you get a worksheet from an outside source, you have to remove the excess formatting, which you will learn in the chapter on Inquire in this tutorial. This will unnecessarily increases the file size. You should not set the criteria for unwanted range of cells or for the entire column. In our example, it can vary from 10 – 100 based on where the worksheet will be used. You need to set the criteria for maximum number of cells that are possible to be used. Now, you are ready to apply the Data Validation criteria to all the cells in the Risk Category column.Īt this point, you need to remember two things − Set Valid Criteria for the Risk Category Column Note − It is very important to check the spelling and grammar of your messages. You have successfully set the Data Validation for the cell. You have an option to either Retry or Cancel.Error message that you have set for the cell will be displayed. You can see that the selection of valid values is working fine.įinally, try to enter an invalid entry and verify the Error alert. Note that if the number of values is more, you will get a scroll-down bar on the right side of the dropdown list. The drop-down list appears with the values that can be selected.Ĭross-check the values in the drop-down list with those that are used to create the drop-down list.īoth the sets of values match. The input message is correctly displayed.Ĭlick on the dropdown button on the right side of the cell. The dropdown button appears on the right side of the cell. In the box under Error message: type Choose a value from dropdown list.įor the selected first cell under Risk Category,Ĭlick in the cell for which you have set Data Validation criteria.In the box under Title:, type Invalid Entry:.Check the box Show error alert after invalid data is entered.Click the Error Alert tab in the Data validation dialog box.In the box under Input message: Choose the Category of the Risk from the List.In the box under Title:, type Risk Category:.Check the box Show input message when cell is selected.Click the Input Message tab in the Data Validation dialog box. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |