O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Choosing Preferences for Error Checking

Excel can automatically identify various errors in your formulas. To choose which errors Excel marks, you set the error-checking preferences. Choose Excel images Preferences or press Cmd+, (Cmd and the comma key) to display the Excel Preferences dialog box, and then click the Error Checking icon in the Formulas and Lists area to display the Error Checking pane (see Figure 5–5).

images

Figure 5–5. In the Error Checking pane of the Excel Preferences dialog box, choose whether to use background error checking and decide ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required