{"id":978,"date":"2024-02-29T05:13:20","date_gmt":"2024-02-28T23:43:20","guid":{"rendered":"https:\/\/sheetstips.com\/?p=978"},"modified":"2024-02-29T12:30:42","modified_gmt":"2024-02-29T07:00:42","slug":"show-formulas-instead-of-values-in-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/show-formulas-instead-of-values-in-google-sheets\/","title":{"rendered":"How To Show Formulas Instead of Values in Google Sheets?"},"content":{"rendered":"<p>Google Spreadsheet software is a great tool where we can create magic with our datasets. We use various formulas and functions to structure, organize, and perform mathematical operations in Google Sheets. But, when we are using functions or formulas in Google Sheets, we just the result not the formula or function used. However, the spreadsheet also allows us to see what formula or function is used in a particular cell with the help of its in-built feature.<\/p>\n<p>Read Also: <a href=\"https:\/\/btechgeeks.com\/python-program-to-compute-the-value-of-eulers-number-using-the-formula-e-1-1-1-1-2-1-n\/\" target=\"_blank\" rel=\"noopener\">Python Program to Compute the Value of Euler\u2019s Number ,Using the Formula: e = 1 + 1\/1! + 1\/2! + \u2026\u2026 1\/n!<\/a><\/p>\n<p>In this article, let&#8217;s understand how to view formulas instead of values in spreadsheet cells with the help of <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheet tips<\/a><\/strong> provided on this page. Read on to find more.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#How-to-Show-Formulas-Instead-of-Values-in-Entire-Google-Sheets?\">How to Show Formulas Instead of Values in Entire Google Sheets?<\/a><\/li>\n<li><a href=\"#How-to-Show-both-Formula-and-Values-at-the-Same-Time?\">How to Show both Formula and Values at the Same Time?<\/a><\/li>\n<li><a href=\"#How-to-Show-Formula-by-Converting-it-to-Text?\">How to Show Formula by Converting it to Text?<\/a><\/li>\n<li><a href=\"#How-to-Show-formulas-instead-of-values-in-Google-Sheets-using-Keyboard-Shortcut?\">How to Show formulas instead of values in Google Sheets using Keyboard Shortcut?<\/a><\/li>\n<li><a href=\"#Shows-Formulas-instead-of-Values-by-Clicking-on-Cell\">Shows Formulas instead of Values by Clicking on Cell<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"How-to-Show-Formulas-Instead-of-Values-in-Entire-Google-Sheets?\">How to Show Formulas Instead of Values in Entire Google Sheets?<\/h2>\n<p>Let&#8217;s consider the following dataset. Here I have various formulas in each cell of the spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-980 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"952\" height=\"401\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values.png 952w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values-300x126.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values-768x323.png 768w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Now follow the steps as listed below to show formulas instead of values:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet where you would like to show formulas instead of values.<\/li>\n<li><strong>Step 2:<\/strong> Click on the &#8220;<strong>View<\/strong>&#8221; tab in the menubar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-983 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values3.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"532\" height=\"351\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values3.png 532w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values3-300x198.png 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> Now select &#8220;<strong>Show Formulas<\/strong>&#8221; from the drop-down menu.<\/li>\n<li><strong>Step 4:<\/strong> This will automatically show formulas instead of values in Google Sheets.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-982 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values2.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"731\" height=\"469\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values2.png 731w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values2-300x192.png 300w\" sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/p>\n<p>This strategy can help you grasp what&#8217;s going on in a spreadsheet that you are unfamiliar with. Looking at someone else&#8217;s work is also a great approach to learn how to use formulas and analysis tools.<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/iferror-function-google-sheets\/\">Using IFERROR Function in Google Sheets with Examples and Formulas<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/importdata-google-sheets\/\">How to Use IMPORTDATA function in Google Sheets? (Fetch CSV\/TSV File)<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/combine-formula-and-text-in-google-sheets\/\">How to Combine Formula and Text in Google Sheets: 2 Easy Methods<\/a><\/li>\n<\/ul>\n<p>This view is very useful when analyzing a workbook that appears to be returning incorrect values. This allows you to see all of the formulas at once rather than having to click on each cell to figure out what&#8217;s going on.<\/p>\n<p>In order to convert back formulas to values follow the steps as listed below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Hit the View tab in Google Sheets menubar.<\/li>\n<li><strong>Step 2:<\/strong> Now uncheck &#8220;<strong>Show Formulas<\/strong>&#8221; from the drop-down menu.<\/li>\n<\/ul>\n<p>This will show values now instead of formulas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-981 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values1.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"338\" height=\"345\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values1.png 338w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values1-294x300.png 294w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><\/p>\n<h3 id=\"How-to-Show-both-Formula-and-Values-at-the-Same-Time?\">How to Show both Formula and Values at the Same Time?<\/h3>\n<p>In Google Sheets, we can see both formulas and values at the same time. To know how to do this, follow the steps as listed below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cell where you would like to view the formula.<\/li>\n<li><strong>Step 2:<\/strong> Double click the cell to see the detailed functions of the cell.<\/li>\n<li><strong>Step 3:<\/strong> Click on the <strong>&#8220;?&#8221;<\/strong> icon next to the cell to bring up the pop-up value preview. Alternatively, you can also &#8220;<strong>F9<\/strong>&#8221; key to enable the pop-up value preview.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-979 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-value7.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"498\" height=\"152\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-value7.png 498w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-value7-300x92.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/p>\n<p>These tricks come in handy when trying to understand what&#8217;s going on with a particular formula in the cell. So you can fix formulas and see all the information at once.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-985 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values5.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"234\" height=\"82\" \/><\/p>\n<h3 id=\"How-to-Show-Formula-by-Converting-it-to-Text?\">How to Show Formula by Converting it to Text?<\/h3>\n<p>This method can be adopted if you want the values to display as formulas permanently.<\/p>\n<p>In order to compel Sheets to show instead than process a formula, you only need to place the formula in apostrophe before it.<\/p>\n<p>Google Sheets doesn&#8217;t include a right-click menu or other formatting choices to control cell formatting, unlike other cell formatting approaches. Changing the formula in the cell is the only option.<\/p>\n<p>Now follow the steps listed below to show formulas by converting them to text.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cell where you would like to show formulas instead of values.<\/li>\n<li><strong>Step 2:<\/strong> Now simply add an apostrophe before the formula.<\/li>\n<li><strong>Step 3:<\/strong> Press the &#8220;<strong>Enter<\/strong>&#8221; button. The apostrophe will be hidden in Google Sheets and the only formula will be displayed as shown below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-986 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values6.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"837\" height=\"252\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values6.png 837w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values6-300x90.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-values6-768x231.png 768w\" sizes=\"(max-width: 837px) 100vw, 837px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Your formula will be displayed instead of the value when the apostrophe symbol is used. Apostrophes in one cell will replace all cell contents with that cell&#8217;s value if you try to move the value across a range. When you add an apostrophe to a calculation, Sheets will not automatically modify the formulas.<\/p>\n<h3 id=\"How-to-Show-formulas-instead-of-values-in-Google-Sheets-using-Keyboard-Shortcut?\">How to Show formulas instead of values in Google Sheets using Keyboard Shortcut?<\/h3>\n<p>This is one of the easiest methods where you don&#8217;t have to execute multiple steps. The steps to achieve &#8220;<strong>shows formulas instead of values<\/strong>&#8221; are given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet.<\/li>\n<li><strong>Step 2:<\/strong> Now simply use the following keys on your keyboard &#8221; <strong>Control<\/strong>,\u201d and \u201c<strong>Accent<\/strong>&#8220;. (<strong> Ctrl + `<\/strong>)<\/li>\n<li><strong>Step 3:<\/strong> Press all the keys in one go. This will show formulas now instead of values in Google Sheets.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-987 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formulas-instead-of-values.jpg\" alt=\"show formulas instead of values\" width=\"363\" height=\"139\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formulas-instead-of-values.jpg 363w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formulas-instead-of-values-300x115.jpg 300w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/p>\n<h3 id=\"Shows-Formulas-instead-of-Values-by-Clicking-on-Cell\">Shows Formulas instead of Values by Clicking on Cell<\/h3>\n<p>This is one of the normal methods where you can simply show formulas instead of values. Just double click on the cell and the Google Sheets will show formulas instead of values. The limitation of this method is that we have to execute this step at each and every cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-979 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-value7.png\" alt=\"show-formulas-instead-of-values-in-google-sheets\" width=\"498\" height=\"152\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-value7.png 498w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/show-formula-instead-of-value7-300x92.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/p>\n<p>Must Read:<\/p>\n<p><a href=\"https:\/\/paisaalgo.com\/metropolis-pivots-calculator\/\">METROPOLIS Pivot Point Calculator<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Spreadsheet software is a great tool where we can create magic with our datasets. We use various formulas and functions to structure, organize, and perform mathematical operations in Google Sheets. But, when we are using functions or formulas in Google Sheets, we just the result not the formula or function used. However, the spreadsheet &#8230; <a title=\"How To Show Formulas Instead of Values in Google Sheets?\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/show-formulas-instead-of-values-in-google-sheets\/\" aria-label=\"More on How To Show Formulas Instead of Values in Google Sheets?\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[167],"jetpack_featured_media_url":"","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/978"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=978"}],"version-history":[{"count":4,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/978\/revisions"}],"predecessor-version":[{"id":4952,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/978\/revisions\/4952"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}