General Preferences

General preferences (Figure 11) control basic Excel operations. There is one main category—Settings—and a number of other options.

Figure 11. The default options in the General pane of the Preferences dialog.

Settings

The Settings options offer check boxes to set a variety of options:

  • R1C1 reference style changes the style of cell references so both rows and columns have numbers.

  • Ignore other applications prevents the exchange of data with other applications that use Dynamic Data Exchange (DDE).

  • Macro virus protection displays a warning like the one in Figure 12 when you open an Excel workbook file that contains macros or customized ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.