Excel Show Formulas Shortcut: How to Quickly Display Formulas in Your Spreadsheets

Understanding Excel Formulas and Shortcuts

Basics of Excel Formulas

Excel is a popular spreadsheet program that allows users to organize, analyze, and manipulate data. One of the most powerful features of Excel is the ability to use formulas to perform calculations on data. Formulas are equations that use values, cell references, and functions to generate new values.

To create a formula in Excel, users must begin by typing an equal sign (=) followed by the formula. For example, to add the values in cells A1 and A2, the formula would be =A1+A2.

Excel also offers a variety of functions that can be used in formulas. Functions are pre-built formulas that perform specific calculations. For example, the SUM function adds a range of cells together.

Excel Keyboard Shortcuts

Excel offers a wide range of keyboard shortcuts that can help users work more efficiently. Keyboard shortcuts are combinations of keys that perform a specific action.

One useful keyboard shortcut is the Show Formulas shortcut. This shortcut allows users to toggle between displaying the results of formulas and displaying the formulas themselves. To use the Show Formulas shortcut, users can press Ctrl + ` (grave accent).

Users can also use the F2 key to enter edit mode for a cell, allowing them to directly edit the formula in the formula bar.

Other useful keyboard shortcuts in Excel include Ctrl + C to copy selected cells, Ctrl + V to paste copied cells, and Ctrl + Z to undo the last action.

By using keyboard shortcuts, users can increase their productivity and accuracy when working with Excel.


In conclusion, Excel formulas and keyboard shortcuts are powerful tools that can help users work more efficiently and accurately. By understanding the basics of Excel formulas and using keyboard shortcuts, users can streamline their workflow and save time.

Troubleshooting and Advanced Features

Protecting and Hiding Formulas

Excel users can protect and hide formulas to prevent unauthorized access, accidental modification, or deletion. This is particularly useful when sharing workbooks with other users. To protect a sheet, users can go to the “Format Cells” dialog box, select the “Protection” tab, and check the “Locked” option. Then, they can go to the “Review” tab, click on “Protect Sheet,” and enter a password. To hide formulas, users can go to the “Excel Options” dialog box, select the “Advanced” tab, and under the “Display options for this worksheet” section, uncheck the “Show formulas in cells instead of their calculated results” option. Alternatively, users can use the “Format Cells” dialog box to apply the “Custom” number format of three semicolons to selected cells, which will hide their values and formulas.

Auditing and Inspecting Formulas

Excel offers several tools to audit and inspect formulas, which can help users verify their accuracy, debug errors, and improve their efficiency and productivity. To audit formulas, users can use the “Formula Auditing” group on the “Formulas” tab, which includes options such as “Trace Dependents,” “Trace Precedents,” “Error Checking,” and “Evaluate Formula.” To inspect formulas, users can use the “Formulatext” function, which allows them to display the formula of a cell as text in another cell, or the “Find and Replace” feature, which allows them to search for and replace specific formulas or values in a range of cells. Additionally, users can use macros or VBA to automate formula auditing and inspection tasks.

Be concise, clear, and to the point. Use bullet points and tables where appropriate.


  • Collin Bennett

    eagle-eyed fact-checker at the heart of every post's accuracy. In an age where information is abundant and mistakes are costly, Samuel stands as the gatekeeper of truth for all Excel-related content. His meticulous approach ensures that every formula, every function, and every data-driven insight is both precise and verifiable.

  • James Davis

    Tech geek, excel super-user, software guru, and your go-to guy for all things digital. James has spent over a decade diving deep into the latest software and gadgets, making tech jargon easy for the rest of us. When he's not geeking out over the newest release, he's probably hunting for some new Excel tips as James spent 7 years perfecting his excel skills!

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.