{"id":5315,"date":"2023-03-08T21:13:00","date_gmt":"2023-03-08T21:13:00","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=5315"},"modified":"2024-05-29T18:26:52","modified_gmt":"2024-05-29T18:26:52","slug":"how-to-show-formulas-in-excel-instead-of-the-values","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-show-formulas-in-excel-instead-of-the-values\/","title":{"rendered":"How to show Formulas in Excel Instead of the Values?"},"content":{"rendered":"

Formulas in Excel are the backbone of efficient data management and analysis, enabling you to perform complex calculations, automate tasks, and derive insights with ease. By mastering formulas in Excel, you unlock the potential to streamline your workflow, reduce errors, and make data-driven decisions. Whether you’re crunching numbers for financial reports, analyzing trends, or managing large datasets, the versatility and power of Excel formulas are indispensable. Embrace the full capabilities of formulas in Excel to elevate your productivity and enhance the accuracy of your work. Transform your spreadsheets into powerful tools that not only store data but also provide actionable insights and drive success in your projects.<\/p>\n

This Tutorial Covers:<\/strong><\/p>\n

    \n
  1. Show Formulas in Excel Instead of the Values<\/strong><\/a><\/li>\n
  2. How to Print Formulas in Excel<\/strong><\/a><\/li>\n
  3. In Excel, display formulas rather than just the value of the currently selected cells<\/strong><\/a><\/li>\n
  4. How to Deal With Excel Displaying Formulas Rather Than Calculated Values<\/strong><\/a><\/li>\n<\/ol>\n

    1. Show Formulas in Excel Instead of the Valuescv<\/strong><\/h2>\n

    Step 1:<\/strong> The “Formulas” Tab will appear in the ribbon. Select “Show Formulas” from the “Formula Auditing” group.<\/p>\n

    \"Formulas<\/p>\n

    The formulas in the worksheet will become visible as soon as you click Show Formulas.<\/p>\n

    \"Formulas<\/p>\n

    Since it is a toggle button, you can click on it once more to have the computed result take the place of the formulas.<\/p>\n

    \"Formulas<\/p>\n

    The Excel keyboard shortcut Control +’is another option (you will find this key in the top-left part of the keyboard, under the Escape key).<\/p>\n

    Note:<\/strong> This is a sheet level technique, please note. As a result, only the formulae in the active sheet will be displayed when you use the shortcut or option to Show Formulas. The rest of the worksheets won’t be impacted. You must access that worksheet and utilize this shortcut to display formulas in other worksheets (or ribbon button).<\/p>\n

    You might wish to display the formulas in every worksheet in a workbook if you have a lot of worksheets.<\/p>\n

    The following procedures will display all of Excel’s worksheets’ formulas:<\/strong><\/p>\n

    Step 1: <\/strong>Select the “File” tab. Go to Office by clicking the Excel 2007 button.<\/p>\n

    \"Formulas<\/p>\n

    Step 2:<\/strong> Toggle to “Options.”<\/p>\n

    \"Formulas<\/p>\n

    Step 3:<\/strong> Select Advanced from the left pane. Scroll down to the “Display options for this worksheet” box on the right. Choose the worksheet you wish to display the formulae rather than the values from the drop-down menu.<\/p>\n

    \"Formulas<\/p>\n

    Step 4:<\/strong> Select “Show formulas in cells instead of their calculated outcomes” from the drop-down menu. Select OK.<\/p>\n

    \"Formulas<\/p>\n

    As previously stated, even though it may appear like there are more steps than a shortcut or the “Show Formulae” button in the ribbon, this method is helpful if you have numerous worksheets and want to display the formulas in each worksheet.<\/p>\n

    2. How to Print Formulas in Excel<\/strong><\/h2>\n

    The steps to print formulas in Excel are as follows:<\/strong><\/p>\n

    Step 1:<\/strong> The “Formulas” Tab will appear in the ribbon. Select “Show Formulas” from the “Formula Auditing” group.<\/p>\n

    \"Formulas<\/p>\n

    Step 2:<\/strong> Select the \u201cFile” tab then go to “Print” option.<\/p>\n

    \"Formulas<\/p>\n

    The aforementioned steps would guarantee that the formulas and not the values are printed.<\/p>\n

    3. In Excel, display formulas rather than just the value of the currently selected cells<\/strong><\/h2>\n

    All of the worksheet’s formulas would be visible using the methods discussed so far.<\/p>\n

    However, you could simply want to display the formulas in a few certain cells.<\/p>\n

    As an Excel trainer, for instance, I frequently develop templates that display the formula in one cell and the result in another cell (as shown below).<\/p>\n

    \"Formulas<\/p>\n

    The steps to only display formulas in particular cells in Excel are as follows:<\/strong><\/p>\n

    Step 1:<\/strong> Choose the cell where you wish the formula to appear rather than the value.<\/p>\n

    \"Formulas<\/p>\n

    Step 2:<\/strong> Go to the \u201cHome” tab and select “Find & Select”. After that, choose “Replace” (keyboard shortcut \u2013 Control + H).<\/p>\n

    \"Formulas<\/p>\n

    Step 3:<\/strong> Put = and ‘= in the “Find what” and “Replace with” fields, respectively, of the replace tab in the Find and Replace dialog box. Simply select Replace All.<\/p>\n

    \"Formulas<\/p>\n

    This will display formulas in every cell in the selected cell while leaving the other cells alone.<\/p>\n

    \"Formulas<\/p>\n

    Note:<\/strong> The space character is seen before the equal to sign when the formula is entered with a space before it to make it a text string. The apostrophe isn’t displayed in the cell when the equal to sign is preceded by an apostrophe, which turns the formula into a text string (it shows up only in the formula bar and in the edit mode).<\/p>\n

    4. How to Deal With Excel Displaying Formulas Rather Than Calculated Values<\/strong><\/h2>\n

    In Excel, the cells occasionally display the formula rather than the value.<\/p>\n

    There are a few causes for this possibility. They are:<\/p>\n