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 ...