Forum Discussion

Erfan117's avatar
Erfan117
Copper Contributor
Oct 29, 2020

No formula auto suggestion

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

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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)

  • PReagan's avatar
    PReagan
    Bronze Contributor

    Hello Erfan117,

     

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

      • PReagan's avatar
        PReagan
        Bronze Contributor

        Erfan117 

         

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

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

         

         

         

Resources