Other methods of selecting cells are not disabled, however. This setting applies to all data validation Allow choices. Pressing the Tab key won’t advance to the next field until a satisfactory entry is made. To require a valid entry, deselect the Ignore Blank check box. On the Settings tab, choose a setting from the Allow pop-up menu.ĭata Validation is an interactive dialog its options change depending on what you decide to allow. Or, on the Ribbon’s Data tab, go to the Tools group and click Validate. 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. One way is to make it harder for them to make mistakes when filling out the form.
It’s always a good thing when you can help people fill out a form that you’ve created in Excel 2011 for Mac.