Breaking News & Updates
Excel Q&A: Show formulas in a spreadsheet
A student took a look at our newly created Staff Payment, PAYG, Super spreadsheet file and they wanted to know which formulas are used in the spreadsheet. This is a great question because there are many ways that a spreadsheet like this can be created and we’ll explore these methods in the forthcoming month.
The secret to reveal formulas is the Tilde key at the top left of your keyboard. Simply press Ctrl + ` and all the formulas in the spreadsheet will be revealed. You can then work intelligently on your spreadsheet and make changes fully aware of where numbers are simply entered or where complicated formulas exist.