- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

MS Excel: The Quick Way to Turn Formula AutoComplete On or Off

Posted By April On July 19, 2011 @ 11:32 AM In MS Excel,MS Office Help | 1 Comment

By now I’m sure that you’ve used or last seen Excel’s formula autocomplete.

msex_formula_autocomplete_example [1]

While you could go to the File tab / Options choice to turn it on or off, it’s much faster to do it right in the worksheet.

All you have to do is use Alt + Down Arrow while in a cell of the worksheet.

This is a toggle combination so Alt + Down Arrow again will turn it back on.

On – Off – On – Off… it’s as simple as a key combination without a single trip to the Options dialog.

~ April

Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/ms-excel-the-quick-way-to-turn-formula-autocomplete-on-or-off/

URLs in this post:

[1] Image: http://www.worldstart.com/ms-excel-the-quick-way-to-turn-formula-autocomplete-on-or-off/msex_formula_autocomplete_example/