• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Enable/Disable Display of Formulas in Cells in Excel

Enable/Disable Display of Formulas in Cells in Excel

By Mitch Bartlett 5 Comments

Enable or prevent showing formulas in the spreadsheet in Microsoft Excel. Performing these steps won’t actually change the value of the cell. It will only allow you to view the formula within the cell.

For all Windows versions of Microsoft Excel, you can simply hold down the “Ctrl” key on your keyboard and press `. This key is called the “grave accent” and is usually located to the right of the number 1 on most keyboards. Here are some other methods you can use.

  1. Select the “Formulas” tab.
  2. Select the “Show Formulas” button in the “Formula Auditing” area.
    Show Formulas button in Excel 2010

FAQ

The “Show Formulas” and “Formula Auditing” area is missing from the Formulas tab. What do I do?

In Microsoft Outlook 2007 through 2016, you can customize the ribbon. That means that the “Show Formulas” and “Formula Auditing” options can be removed, and not exist on your computer. You can often add it back by going to the “Customize Quick Access Toolbar” arrow, then choose “More Commands“.

Excel More Commands option

From there, you can choose “Customize Ribbon“, then add the “Formula Auditing” section anywhere you want it. You could also use the “Reset” button on this screen to reset your customization back to default settings.

Adding Show Formulas option to Excel ribbon

You Might Also Like

  • Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
    Copy and Paste Values Without Formulas in Excel 2019, 2016,…
  • Excel 2016: How to Lock or Unlock Cells
    Excel 2016: How to Lock or Unlock Cells
  • Galaxy Note8: Disable "Always On" Display
    Galaxy Note8: Disable "Always On" Display
  • Enable Slashes (/) in Excel 2016
    Enable Slashes (/) in Excel 2016
  • Excel: Permanently Disable Compatibility Checker Dialog
    Excel: Permanently Disable Compatibility Checker Dialog
  • Enable "Send to Mail Recipient" Option in Excel & Word 2019
    Enable "Send to Mail Recipient" Option in Excel & Word 2019
  • Google Sheets: Set Cells to Same Size
    Google Sheets: Set Cells to Same Size
  • Google Sheets: Protect Cells
    Google Sheets: Protect Cells
  • Google Sheets: Remove Formatting From Cells
    Google Sheets: Remove Formatting From Cells

Filed Under: Office Tagged With: Excel 2013, Excel 2016

Reader Interactions

Comments

  1. Bal Gaire says

    July 29, 2019 at 6:31 am

    1. When I enter word in cell one it reflect automatically in another.
    2. When I work in v lookup function it disable the Data tools from the excel.

  2. Bekki Toth says

    October 29, 2018 at 4:59 pm

    I have to stop a formula on the 31st of oct and set it to start again on the 1st of november. This is Weds and Thursday of same week. How is the best way to do this?

  3. Shon says

    July 30, 2018 at 12:56 pm

    Hey, Jerry in Texas. See if this works: On the View tab, under “Show” uncheck the Formula Bar.

  4. Shon says

    July 30, 2018 at 12:49 pm

    Formulas show despite using the grave accent and the Show Formulas option in the Formula Auditing pane.

  5. J. Pousson says

    June 23, 2018 at 11:36 am

    when I click a cell in Excel the formula often, but not always, displays in the cell and in the formula bar area.
    I find this very annoying and has caused frequent errors. I much prefer using the formula bar and need to find a way of not displaying formulas in both the cell and formula bar…I don’t recall this occurring in earlier work in Excel workbooks…Please help, I can not find a solution on the Internet.. The suggestion using CTRL+tilde key causes formulas to display over the entire worksheet and for me is useless…Thanks for any help you might share. Jerry in Texas

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Recent Posts

  • Windows 11: How to Fix Windows 11 Won’t Connect to a Network
  • What to Do When Firefox Won’t Load a Page
  • Chrome: How to Refresh Various Tabs Simultaneously
  • The Latest Foldable Phones – A Look At The Huawei Mate X2
  • Everything Announced at Google I/O 2022 That You Should Care About
  • How to Build the Best High-Spec PC for Your Budget
  • Google Shows Off Pixel 7 and Pixel Watch Ahead of Fall Launch
  • Windows 11: How to View Saved Passwords

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2022 Technipages · All Rights Reserved · Privacy