Forum Discussion
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 formula itself ?
9 Replies
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.
I know I don't know anything (Socrates)
- 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
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 spreadsheetAnother 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 First make sure Formulas -> Show Formulas isn't turned on:
If it is (like shown above) then click it off.
Next make sure the cell isn't set to TEXT:
Set it to GENERAL instead
next make sure their aren't any special characters at the beginning.
After doing the above, click in the cell and retype (at the very least deleting the "=" and anything before is and retyping that "=")
