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.


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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.