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