Posted on

Microsoft Excel Quick Command to show the Formulas in a spreadsheet

Breaking News & Updates

@danwarne Hi @danwarne If you're using Xero you'd have access to Hubdoc - But we believe Dext (ex ReceiptBank) is very good. Divipay uses Slyp so you get smart receipts in your software!…

About a month ago from Steve Slisar's Twitter via Twitter Web App

Excel Q&A: Show formulas in a spreadsheet

Microsoft Excel online training course keyboard shortcutsA 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.

Note: Our Excel Q&A service (just like our MYOB Q&A support) is designed to provide extra training content over and above the examples that are in our online Microsoft Excel Training Course.

-- Did you like what you read? Want to receive these posts via email when they are published? Subscribe below.

Enter your email address:

Content Marketing by 123ezy