{"id":2070,"date":"2015-04-21T10:15:40","date_gmt":"2015-04-21T10:15:40","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2070"},"modified":"2023-12-31T00:06:12","modified_gmt":"2023-12-31T00:06:12","slug":"show-formulas-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/show-formulas-in-excel\/","title":{"rendered":"Show Formulas in Excel"},"content":{"rendered":"

Make sense of someone else’s\u00a0workbook<\/h2>\n

When you are given a workbook that has already been created it can be hard to work out which cells contain\u00a0manually entered values and which cells are the result of formulas. So how do you show formulas in Excel?<\/p>\n

Below is an example workbook, at first glance it’s not easy to see how the figures in Qtr 1 and Qtr2 were generated.\u00a0This is a problem if you need to maintain the workbook or check it’s formulas.<\/p>\n

\"show<\/a><\/p>\n

Excel can reveal the true contents of cells – so its easy to\u00a0locate formulas in the sheet.<\/p>\n

\"show<\/a><\/p>\n

How you can show formulas in Excel:<\/h2>\n

There are two ways to switch this feature on. Using the Ribbon click on the Formulas tab and then click the Show Formulas button<\/p>\n

\"Show<\/a>
Show Formulas in Excel<\/figcaption><\/figure>\n

 <\/p>\n

The button is a toggle switch so click it to turn the feature on. Click again to turn it off.<\/p>\n

You can also switch this feature on and off using the keyboard shortcut:\u00a0Ctrl + `\u00a0 (this symbol is\u00a0usually on the key to the left of the number 1 key, in the\u00a0top left corner of the keyboard. It is the grave accent character).<\/p>\n

Tip:<\/strong> You can print the sheet with show formulas switched on to make it easier to review the construction of your workbook.<\/p>\n

Additional Resources<\/h3>\n

A Hidden Gem In Excel – Formula Auditing<\/a><\/p>\n

Hide an Excel formula and protect your workbook from unwanted changes<\/a><\/p>\n

Introduction to the language of formulas in Excel<\/a><\/p>\n

Excel formulas not working?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Make sense of someone else’s\u00a0workbook When you are given a workbook that has already been created it can be hard to work out which cells contain\u00a0manually entered values and which cells are the result of formulas. So how do you show formulas in Excel? Below is an example workbook, at first glance it’s not easy […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[169,300],"class_list":["post-2070","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-evaluate-formulas","tag-how-to-show-formulas-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2070"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2070\/revisions"}],"predecessor-version":[{"id":6888,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2070\/revisions\/6888"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}