Discussion Re: where is the result ? in Excel
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248327#M137088
<P><LI-USER uid="1324836"></LI-USER> </P><P><SPAN class=""><SPAN class=""><SPAN>Start Excel and call up the desired document.</SPAN></SPAN> </SPAN></P><P><SPAN class=""><SPAN class=""><SPAN>If you are working in the Office 365 version of Excel, </SPAN></SPAN></SPAN></P><P><SPAN class=""><SPAN class=""><SPAN>press the key combination (CTRL) + (Shift) and (´).</SPAN></SPAN> </SPAN></P><P><SPAN class=""><SPAN class=""><SPAN>In older versions of the software you must use the combination (Ctrl) + (#).</SPAN></SPAN> </SPAN></P><P> </P><P><SPAN class=""><SPAN class=""><SPAN>After pressing the key combination once, </SPAN></SPAN></SPAN><SPAN class=""><SPAN class=""><SPAN>you should only see the result again as usual and no longer the entire formula.</SPAN></SPAN></SPAN></P><P> </P><P>Hope I was able to help you with this information.</P><P> </P><P><A href="https://techcommunity.microsoft.com/t5/excel-blog/meet-niko-chatzoudis-excel-forum-contributor/ba-p/2941385" target="_blank" rel="noopener">NikolinoDE</A></P><P>I know I don't know anything (Socrates)</P>Sat, 05 Mar 2022 16:47:36 GMTNikolinoDE2022-03-05T16:47:36Zwhere is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248317#M137086
<P>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 ?</P>Sat, 05 Mar 2022 16:37:30 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248317#M137086Stanger68042022-03-05T16:37:30ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248325#M137087
<P><LI-USER uid="1324836"></LI-USER> First make sure Formulas -> Show Formulas isn't turned on:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mtarler_0-1646498501377.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/353273i65E6FF64C72F1CFB/image-size/medium?v=v2&px=400" role="button" title="mtarler_0-1646498501377.png" alt="mtarler_0-1646498501377.png" /></span></P><P>If it is (like shown above) then click it off.</P><P>Next make sure the cell isn't set to TEXT:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mtarler_1-1646498558889.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/353272i2E8F61EBBB75E3AB/image-size/medium?v=v2&px=400" role="button" title="mtarler_1-1646498558889.png" alt="mtarler_1-1646498558889.png" /></span></P><P>Set it to GENERAL instead</P><P>next make sure their aren't any special characters at the beginning.</P><P>After doing the above, click in the cell and retype (at the very least deleting the "=" and anything before is and retyping that "=")</P><P> </P><P> </P><P> </P>Sat, 05 Mar 2022 16:44:33 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248325#M137087mtarler2022-03-05T16:44:33ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248327#M137088
<P><LI-USER uid="1324836"></LI-USER> </P><P><SPAN class=""><SPAN class=""><SPAN>Start Excel and call up the desired document.</SPAN></SPAN> </SPAN></P><P><SPAN class=""><SPAN class=""><SPAN>If you are working in the Office 365 version of Excel, </SPAN></SPAN></SPAN></P><P><SPAN class=""><SPAN class=""><SPAN>press the key combination (CTRL) + (Shift) and (´).</SPAN></SPAN> </SPAN></P><P><SPAN class=""><SPAN class=""><SPAN>In older versions of the software you must use the combination (Ctrl) + (#).</SPAN></SPAN> </SPAN></P><P> </P><P><SPAN class=""><SPAN class=""><SPAN>After pressing the key combination once, </SPAN></SPAN></SPAN><SPAN class=""><SPAN class=""><SPAN>you should only see the result again as usual and no longer the entire formula.</SPAN></SPAN></SPAN></P><P> </P><P>Hope I was able to help you with this information.</P><P> </P><P><A href="https://techcommunity.microsoft.com/t5/excel-blog/meet-niko-chatzoudis-excel-forum-contributor/ba-p/2941385" target="_blank" rel="noopener">NikolinoDE</A></P><P>I know I don't know anything (Socrates)</P>Sat, 05 Mar 2022 16:47:36 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248327#M137088NikolinoDE2022-03-05T16:47:36ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248330#M137090
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 modeSat, 05 Mar 2022 16:52:42 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248330#M137090mtarler2022-03-05T16:52:42ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248336#M137092
<P><LI-USER uid="570951"></LI-USER> </P><P>Hi Matt,</P><DIV class=""><SPAN class=""><SPAN class=""><SPAN>ITried it again with Excel 2016...it works...shows all formulas in the worksheet and vice versa.</SPAN></SPAN> </SPAN></DIV><DIV class=""><SPAN class=""><SPAN class=""><SPAN>The single quote can easily be confused with the back quote.</SPAN></SPAN> </SPAN></DIV><DIV class=""><SPAN class=""><SPAN class=""><SPAN>A back quote is needed here.</SPAN></SPAN> </SPAN></DIV><DIV class=""> </DIV><DIV class=""><SPAN class=""><SPAN class=""><SPAN>Excel keyboard shortcut shows formulas in the whole spreadsheet</SPAN></SPAN> </SPAN></DIV><DIV class=""><SPAN class=""><SPAN class=""><SPAN>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).</SPAN></SPAN> </SPAN></DIV><DIV class=""><SPAN class=""><SPAN class=""><SPAN>For older versions of Excel, you must press the Excel key combination [CTRL] + [#].</SPAN></SPAN></SPAN></DIV><DIV class=""><DIV class=""> </DIV></DIV>Sat, 05 Mar 2022 17:07:21 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248336#M137092NikolinoDE2022-03-05T17:07:21ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248340#M137094
You're right, now I see it too... got it wrong in the first post... sry<BR />I inserted single quote instead of back quote. In the heat of the moment, my fingers were quicker than my eyes.<BR /><BR />Thanks for the hint <LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI>Sat, 05 Mar 2022 17:11:15 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248340#M137094NikolinoDE2022-03-05T17:11:15ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248341#M137095
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 !!Sat, 05 Mar 2022 17:11:38 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248341#M137095Stanger68042022-03-05T17:11:38ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248427#M137115
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+~Sun, 06 Mar 2022 00:30:48 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248427#M137115mtarler2022-03-06T00:30:48ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248527#M137129
Matt, you're right again, the shortcut is for German keyboard. Since back quote in the German keyboard can only be reached with Shift.<BR />This is what happens when you want to help internationally and national tools are used for this :). Well, the main thing is that the user is helped... and me too <LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI><BR /><BR />Thanks again for the useful notices.Sun, 06 Mar 2022 11:59:27 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248527#M137129NikolinoDE2022-03-06T11:59:27ZRe: where is the result ?
https://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248620#M137146
no problem and we are all learning. It is very interesting that your ` needs a shift. Actually what I learned most, is to avoid using the SHIFT+ in the hot key definition. I always wondered if CTRL+SHIFT+R made sense. Shouldn't it be CTRL+R or CTRL+SHIFT+r. Ok in that case it is pretty obvious what is meant, but with symbols or numbers that (obviously) gets more complicated. Well as you like to quote, If there is anything I know: "I know I don't know anything (Socrates)"Sun, 06 Mar 2022 17:42:27 GMThttps://techcommunity.microsoft.com/t5/excel/where-is-the-result/m-p/3248620#M137146mtarler2022-03-06T17:42:27Z