*Excel 2011 For Mac Update
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:
Question: In Microsoft Excel 2011 for Mac, I have a spreadsheet with column headings. I need a way to scroll down the rows, but still see the column headings that are contained in the top row. How can I do this? Answer: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel. Retrieving an AutoRecover file in Excel for Mac 2011. If your computer or Excel crashes, you can recover your work up to the most recent AutoRecover save, but only if you turned on AutoRecover saves. Take these steps to restore any workbooks that were open at the time of the crash: Click the Excel Dock icon.Excel 2011 For Mac Update
*
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.
