Office 2011 for Mac: Validate Data on Excel Forms
It’s always a good thing when you can help people fill out a form that you've created in Excel 2011 for Mac. One way is to make it harder for them to make mistakes when filling out the form. For example, by using data validation in Excel 2011 for Mac, you can make sure that someone enters a particular kind of data (such as a date, number, or text) into an input field.
Follow these steps to use validation in Excel 2011 for Mac:
Select an input field.
Choose Data→Validation. Or, on the Ribbon’s Data tab, go to the Tools group and click Validate.
On the Settings tab, choose a setting from the Allow pop-up menu.
Data Validation is an interactive dialog; its options change depending on what you decide to allow.
To require a valid entry, deselect the Ignore Blank check box. Pressing the Tab key won't advance to the next field until a satisfactory entry is made. This setting applies to all data validation Allow choices. Other methods of selecting cells are not disabled, however.
(Optional) On the Input Message tab, give your message a title and type an input message in the Input Message field.
The input message appears in a ScreenTip when you select the input field in a protected form.
(Optional) On the Error Alert tab, select an error alert style and then type an error message in the Title and Error message field.
Customize the error message that a user gets if he fails to follow the data validation rule you create. Try not to be sarcastic in these messages. After all, you don’t want to hurt feelings or ruffle feathers.
Click OK to apply the validation rules and close the Data Validation dialog.