- 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 | Comments Disabled
By now I’m sure that you’ve used or last seen Excel’s formula autocomplete.
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.
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:
 Image: http://www.worldstart.com/ms-excel-the-quick-way-to-turn-formula-autocomplete-on-or-off/msex_formula_autocomplete_example/