moderated Re: Excel 2016
toggle quoted messageShow quoted text
Ok, hopefully this might help.
Auto Formula complete will only work if the setting, Allow editing directly in cells, is turned on.
So here is where to find both settings.
Turn on / off Auto Formula complete (check if turned on).
Go to File, Options, then in the list, arrow down to formulas.
Then tab about 5 or 6 times until you get to the auto complete check box. Again, needs to be checked.
Next, turn on allow editing directly in cells.
Go to file, options, and in the list arrow down to advanced.
Then tab about 6 or 7 times until you hear, allow editing directly in cells checkbox. Again, this must be turned on in order for the auto formula complete to work.
I have tested this on my system, and if both of these settings are on, then it works just fine.
Hope this helps.
On Aug 15, 2022, at 8:13 AM, John Doering <john.doering@...> wrote: