{"id":6301,"date":"2017-05-24T16:13:19","date_gmt":"2017-05-24T14:13:19","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6301"},"modified":"2024-02-06T16:06:07","modified_gmt":"2024-02-06T15:06:07","slug":"how-to-show-hide-formulas-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-show-hide-formulas-in-excel\/","title":{"rendered":"How to Show &#038; Hide Formulas in Excel"},"content":{"rendered":"<p>When I have a sheet full of Excel formulas, sometimes I want to quickly check how each <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> looks like. \u00a0This is great for <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"spreadsheet\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a> auditing.<\/p>\n<p>It is very easy to do so in Excel!<\/p>\n<p>Here is our sample worksheet with formulas:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Show &amp; Hide Formulas in Excel\"  class=\"alignnone size-full wp-image-6302\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-01.jpg\" alt=\"How to Show &amp; Hide Formulas in Excel\" width=\"465\" height=\"255\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-01.jpg 465w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-01-300x165.jpg 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/a><\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Iqw27J-scuM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-in-Excel-2010.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-in-Excel-2010.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-Hide-Formulas-in-Excel-2010.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Press on your keyboard the following keys:\u00a0<strong>Ctrl + `<\/strong><\/p>\n<p>The (<strong>`<\/strong>) key is usually located on the upper left part of your keyboard. This will show all your Excel formulas in your worksheet!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Show &amp; Hide Formulas in Excel\"  class=\"alignnone size-full wp-image-6303\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-02.jpg\" alt=\"How to Show &amp; Hide Formulas in Excel\" width=\"669\" height=\"208\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-02.jpg 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-02-300x93.jpg 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>Press the <strong>Ctrl + `\u00a0<\/strong>combination again to hide the formulas.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0If you prefer to set this via Excel Options, another way is to go to <strong>File\u00a0&gt; Options<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Show &amp; Hide Formulas in Excel\"  class=\"alignnone size-full wp-image-6304\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-03.jpg\" alt=\"How to Show &amp; Hide Formulas in Excel\" width=\"144\" height=\"171\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0Go to <strong>Advanced<\/strong><strong>&gt;\u00a0Display Options for this Worksheet &gt; Show formulas in cells instead of their calculated fields<\/strong><\/p>\n<p>Ensure this is checked.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Show &amp; Hide Formulas in Excel\"  class=\"alignnone size-full wp-image-6305\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-04.jpg\" alt=\"How to Show &amp; Hide Formulas in Excel\" width=\"559\" height=\"324\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-04.jpg 559w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-04-300x174.jpg 300w\" sizes=\"(max-width: 559px) 100vw, 559px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The formulas are all shown now too! \u00a0You can uncheck it to hide the formulas again.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Show &amp; Hide Formulas in Excel\"  class=\"alignnone size-full wp-image-6306\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-05.jpg\" alt=\"How to Show &amp; Hide Formulas in Excel\" width=\"654\" height=\"194\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-05.jpg 654w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Hide-Formulas-05-300x89.jpg 300w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>How to Show &amp; Hide Formulas in Excel<\/strong><\/span><\/p>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When I have a sheet full of Excel formulas, sometimes I want to quickly check how each formula looks like. \u00a0This is great for spreadsheet auditing. It is very easy to do so in Excel! Here is our sample worksheet with formulas: I explain how you can do this below: \ufeff Download excel workbookHow-to-Hide-Formulas-in-Excel-2010.xlsx STEP [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17551,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,7,10,16],"tags":[254,255],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6301"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6301"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6301\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17551"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}