Forum Discussion

Stanger6804's avatar
Stanger6804
Copper Contributor
Mar 05, 2022

where is the result ?

just created a new spreadsheet.  When entering formulas in a cell, the result does not appear in the cell, just the formula.  What must I do to have the result of the formula appear rather than the f...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Mar 05, 2022

Stanger6804 

Start Excel and call up the desired document.

If you are working in the Office 365 version of Excel,

press the key combination (CTRL) + (Shift) and (´).

In older versions of the software you must use the combination (Ctrl) + (#).

 

After pressing the key combination once, you should only see the result again as usual and no longer the entire formula.

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

mtarler's avatar
mtarler
Silver Contributor
Mar 05, 2022
Hey Niko, What are those hot keys? I tried them and they did some sort of copy value from cell above into this cell and leave in edit mode
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Mar 05, 2022

    mtarler 

    Hi Matt,

    ITried it again with Excel 2016...it works...shows all formulas in the worksheet and vice versa.
    The single quote can easily be confused with the back quote.
    A back quote is needed here.
     
    Excel keyboard shortcut shows formulas in the whole spreadsheet
    Another way to display the formula in a cell is to use the shortcut [CTRL] + [SHIFT] + [`] under Windows, but this only works from Microsoft Office 2016 or Microsoft 365 (formerly Office 365).
    For older versions of Excel, you must press the Excel key combination [CTRL] + [#].
     
    • Stanger6804's avatar
      Stanger6804
      Copper Contributor
      Mar 05, 2022
      Thank you all. The problem was when I originally formatted the spreadsheet, I had set it to text for all. Once I made the correct change for the cells where numbers or currency were located, the problem disappeared !! Again, thanks all.......appreciate the speedy response !!! Thumbs-up to all !!
    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Mar 05, 2022
      You're right, now I see it too... got it wrong in the first post... sry
      I inserted single quote instead of back quote. In the heat of the moment, my fingers were quicker than my eyes.

      Thanks for the hint 🙂
      • mtarler's avatar
        mtarler
        Silver Contributor
        Mar 06, 2022
        Yes it was single quote instead of back quote but I tried both with that in mind but neither worked for me. What did just work was CTRL+` (no SHIFT). By chance do you need to use SHIFT to get to the back quote on your keyboard? On my keyboard SHIFT+` is ~ so CTRL+SHIFT+` is really CTRL+~

Resources