Page 17 - Code & Click - 8
P. 17
To apply data validation rules to a spreadsheet:
1. Create the worksheet as shown in the image.
1
Observe that the values for the Class, Section, and Grade columns are specified separately.
These will be used for creating the validation rules for the corresponding columns.
2. Select the cell range on which you wish to apply a validation rule.
3
2
3. On the Data tab, Click the Data Validation button in the Data Tools group.
The Data Validation dialog box opens.
4
5
4. On the Settings tab, click the Allow list box arrow button and select the List option from the list
that opens.
5. In the Source box, specify the cell range that contains the permitted values for the column.
6. On the Input Message tab, specify a title and a message in the Title and Input message box
respectively.
6 7
8
15
