Click the Office button Click Excel Options.
Click Formulas. Select the Formula AutoComplete check box.
Click OK.