If you're a formula pro, you may find that the AutoComplete feature gets in the way more than it helps.

Formula AutoComplete

To turn it off, go to File, Options, Formulas in Excel 2010 (look under the Office button in Excel 2007) and uncheck the box next to Formula AutoComplete:

Working with formulas

Don't worry, this just sets your default. Whatever your preference, you can quickly toggle Formula AutoComplete on (or off) using Ctrl + Down Arrow when working in the formula editor.

Suzanne