Categories: News

Microsoft Excel Quick Command to show the Formulas in a spreadsheet

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.

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.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

65% OFF Bookkeeping Courses & Office Admin – Winter Price Shrink

It's EOFY time and it's the last chance to pay for your expenses for the…

5 days ago

Top 5 Things Small Businesses Must Do Before June 30 to Get Their EOFY Accounting in Order

As the end of the financial year (EOFY) approaches in Australia, small business owners need…

1 week ago

How EzyLearn Gets Xero Skills Into Your Brain (So They Stick!)

[A casual chat between two friends – Sam, a job seeker wanting to upskill, and…

2 weeks ago

Mastering Xero with EzyLearn: Building Confidence Through Practical Learning

In today's digital landscape, proficiency in cloud-based accounting software like Xero is essential for professionals…

3 weeks ago

Xero gives itself a 90% high distinction – users disagree

Have you seen the recent ads promotion 90+ % approval from their customers? The claims…

1 month ago

Intuit QuickBooks Course updates coming – features and navigation changes

Intuit is hunting for ways of helping their software become more relevant to Australian small…

1 month ago