How to show all formulas in Excel
Next to your number 1 key on the keyboard is the magic "tilde" button.
Use ctrl + ` to show formulas and ctrl + ` to hide formulas.
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
Copilot
Keeping meetings on track with Microsoft Facilitator
How to keep meetings on track with the time bar!
365 Productivity
Pivot Table Hack - Report Filter Pages
Need to create a quick pivot table for each product, each location or maybe each salesperson? Use this simple technique using Report Filter Pages!
365 Productivity
Excel - Percentages
Across all industries and all roles, at some time or another you're going to need to work out the percentage of something.
Take the number, divide by the total and multiply by one hundred over one... just got quicker.