MS Excel: How To Show Formulas In Excel

Added On: Jun 13, 2023

Last Update: Aug 17, 2023

Excel’s formulas are used by each and every user of Excel. When you are using formulas in a worksheet and the count of formulas are more than this is difficult to comprehend, how all the formulas in a worksheet relate to each other.

Excel formulas if displayed in the cell except for their result then it can be helpful to track the worksheet data used in calculations and this is also helpful for fewer errors.

Excel display formulas option is available in each Excel worksheet. You read the complete article you come to know how to show formulas in Excel. Follow the below steps to display formulas in one cell of Excel.

How To Show Formulas In Excel (Quick Guide)

Show or Hide formulas, further steps guide available below

Select a cell containing a formula in the Excel worksheet.
Now press Ctrl key on keyboard and keep hold of this then press ` key present next of number 1.
Hide formulas in Excel, simply again press Ctrl+` to revert the process.

Show All Formulas in a Spreadsheet

Excel also provides a quick and easy way to display formulas in Excel. You can use Excel shortcuts to display formulas in Excel worksheet cells. Shortcut is: Ctrl+’ (in mac) and Ctrl+` (in windows)

Example:

Select a cell containing a formula in the Excel worksheet.
Now press Ctrl key on keyboard and keep hold of this then press ` key present next of number 1.
Hide formulas in Excel, simply again press Ctrl+` to revert the process.

Show Formulas in a Single Cell

Excel also provides another simple way to display formulas in Excel. To Display formulas in the Excel worksheet cell, you need to add the apostrophe (`) symbol at the beginning of the formula.

Example: As shown below image, Cell B1 contains formula =SUM(A1, A2), now what you need to, just add an apostrophe (`) in the front of the formula. This will forces Excel to display Formulas in cells except for values.