moderated Re: Excel 2016


 

Robin,

It's probably the formula autocomplete checkbox.  I didn't know, until I just checked, that this feature can be toggled on/off while editing formulas by hitting ALT + Down Arrow.

It is ON by default, and I'll bet at one point an ALT + Down Arrow was hit during a formula editing that toggled it off.
--

Brian - Windows 10, 64-Bit, Version 21H2, Build 19044  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.
     ~ Lauren Bacall

Join main@jfw.groups.io to automatically receive all group messages.