No formula auto suggestion

%3CLINGO-SUB%20id%3D%22lingo-sub-1832602%22%20slang%3D%22en-US%22%3ENo%20formula%20auto%20suggestion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1832602%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20find%20the%20formula%20auto-suggestion%20when%20I%20type%20%22%3D%22.%20No%20auto-suggestion%20of%20the%20formula%20shows%20up%20in%20any%20of%20my%20excel%20sheets.%3CBR%20%2F%3EHowever%2C%20I%20have%20checked%20the%20formula%20section%20under%20%22Options%22%20where%20the%20%22Formula%20autocomplete%22%20feature%20is%20turned%20ON.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EPlease%20need%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1832602%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1832747%22%20slang%3D%22en-US%22%3ERe%3A%20No%20formula%20auto%20suggestion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1832747%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F850408%22%20target%3D%22_blank%22%3E%40Erfan117%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBegin%20typing%20a%20formula%20such%20as%20%22%3Da%22%20then%20simultaneously%20press%20Alt%20%2B%20Down%20Arrow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1833649%22%20slang%3D%22en-US%22%3ERe%3A%20No%20formula%20auto%20suggestion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1833649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3BThanks.%20I%20tried%20that%2C%20again.%20Still%20not%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1833754%22%20slang%3D%22en-US%22%3ERe%3A%20No%20formula%20auto%20suggestion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1833754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F850408%22%20target%3D%22_blank%22%3E%40Erfan117%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20may%20have%20accidentally%20disabled%20the%20%22Show%20function%20ScreenTips%22%20option%3A%3C%2FP%3E%3CP%3EGo%20to%20Options%2C%20Advanced%2C%20Display%2C%20check%20%22Show%20function%20ScreenTips%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_0-1603990207179.png%22%20style%3D%22width%3A%20550px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F230160iA28EE1519EE2CE88%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PReagan_0-1603990207179.png%22%20alt%3D%22PReagan_0-1603990207179.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1834294%22%20slang%3D%22en-US%22%3ERe%3A%20No%20formula%20auto%20suggestion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1834294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20time!%20But%20the%20main%20issue%20was%20a%20pending%20windows%20update!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I cannot find the formula auto-suggestion when I type "=". No auto-suggestion of the formula shows up in any of my excel sheets.
However, I have checked the formula section under "Options" where the "Formula autocomplete" feature is turned ON.

Please need your help!

8 Replies

Hello @Erfan117,

 

Begin typing a formula such as "=a" then simultaneously press Alt + Down Arrow.

@PReagan Thanks. I tried that, again. Still not working.

@Erfan117 

 

Perhaps you may have accidentally disabled the "Show function ScreenTips" option:

Go to Options, Advanced, Display, check "Show function ScreenTips".

PReagan_0-1603990207179.png

 

 

 

@PReagan Thanks for your time! But the main issue was a pending windows update! 

@Erfan117 

 

You're welcome! Glad that you were able to sort it out!

@PReagan Hey! Guess what! The issue is back again. It is really getting annoying! The last option that you asked to tick is already ticked. I cannot understand whats going on!

@Erfan117 

 

Unfortunately, I think this may be beyond my depth of Excel knowledge. If a pending windows update was the solution last time, then I can only make the assumption that it has something to do with the windows update that you installed or that you do not have the most current windows update. However, I will have to defer to the rest of the community for a more concrete answer.

@Erfan117 

With the permission of everyone involved,

In Microsoft Excel, the Auto-Complete feature may not fill in the remaining characters if the algorithm that Excel uses detects a header row in the list.

Auto-Complete may not work

https://docs.microsoft.com/en-us/office/troubleshoot/excel/autocomplete-not-work

 

I hope I was able to contribute a little to the solution or to the identification of the cause

 

Nikolino

I know I don't know anything (Socrates)