Yes or No

Highlight the cells

This example shows you how to display a drop-down list so the user can only select Yes or No.
Select the cells you want to apply this restriction to. In this case

alt text

Enter the Criteria

Display the Data tab and find the Data Tools group.
Press Data Validation to display the Data Validation dialog box and select the Settings tab.
Select List from the Allow drop-down list.
Enter the text "Yes,No" in the Source text box.

alt text

Press OK to apply the data validation.

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext