Forum Discussion
Stanger6804
Mar 05, 2022Copper Contributor
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...
mtarler
Mar 05, 2022Silver Contributor
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+~
NikolinoDE
Mar 06, 2022Platinum Contributor
Matt, you're right again, the shortcut is for German keyboard. Since back quote in the German keyboard can only be reached with Shift.
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 🙂
Thanks again for the useful notices.
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 🙂
Thanks again for the useful notices.
- mtarlerMar 06, 2022Silver Contributorno 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)"