Change Formula Options : Formula « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Formula

Click the Office button, and then click Excel Options.

In the left pane, click Formulas. 
           Select the calculation options you want:
           Workbook Calculation.
           Enable iterative calculation.
           R1C1 reference style.
           Formula AutoComplete.
           Use table name in formulas.
           Use GetPivotData functions for PivotTable references.

6.1.Formula
	6.1.1.	Enter a Formula
	6.1.2.	Display Formulas in Cells
	6.1.3.	Copy a Formula Using AutoFill
	6.1.4.	Copy a Formula Using the Clipboard
	6.1.5.	Use Paste Special to copy only formulas
	6.1.6.	Use keyboard commands to recalculate formulas
	6.1.7.	Convert a Formula to a Value
	6.1.8.	Print formulas
	6.1.9.	Change Formula Options
	6.1.10.	Include a link in a formula
	6.1.11.	Hide or Show Formulas
	6.1.12.	Select the calculating options