• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to hide formulas but still show results in Excel

0 Comments

How to hide formulas but still show results in Excel: Sometimes, you may want others to see the results of your spreadsheet without knowing the formulas you used to calculate them. In this case, you need to hide those formulas. This article will show you how to hide the formula of an Excel cell while still displaying the result.

Hide the formula of the cell

For example, let’s say we want to “hide” the formula in cell G2 in the image below. Follow these steps:

How to hide formulas but still show results in Excel

How to hide formulas but still show results in Excel

Step 1: Right-click on cell G2 and select Format Cells… or use the shortcut Ctrl + 1 to open the Format Cells dialog box.

How to hide formulas but still show results inStep 2: In the Format Cells dialog box, select the Protection tab. Then, check the Hidden box and click OK.

How to hide formulas but still show results inStep 3: Next, select the Review tab. Then, choose Protect Sheet under the Changes section.

How to hide formulas but still show results inStep 4: Now, the Protect Sheet dialog box appears. Enter a password in the Password to unprotect sheet box and click OK to finish.

How to hide formulas but still show results inNext, re-enter the same password in the Reenter password to proceed box and click OK.

How to hide formulas but still show results in Excel

How to hide formulas but still show results in Excel

Now, the formula in cell G2 is hidden, but the result is still displayed normally.

How to hide formulas but still show results inTo display the formula again, select the Review tab. Then, choose Unprotect Sheet under the Changes section.

How to hide formulas but still show results inEnter the password you set earlier in the Password box in the Unprotect Sheet dialog box. Then, click OK.

How to hide formulas but still show results inThe formula in cell G2 that was hidden earlier will now be displayed normally.

How to hide formulas but still show results in Excel

How to hide formulas but still show results in Excel

That’s it! This article has shown you how to hide formulas in Excel cells. Hopefully, this article will be useful to you in your work on Excel. Good luck!

Rate this post
35
250 Views
Converting Time Values into Decimal Numbers (Hours) in ExcelPrevConverting Time Values into Decimal Numbers (Hours) in ExcelMay 6, 2023
4 Types Of Charts To Avoid Using In Excel DashboardsMay 6, 20234 Types Of Charts To Avoid Using In Excel DashboardsNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
Products
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global Windows Server 2022 Standard Key Global
    Rated 4.10 out of 5
    $7.00
  • Windows Server 2012 R2 Datacenter Key Global Windows Server 2012 R2 Datacenter Key Global
    Rated 4.71 out of 5
    $15.00
  • Kaspersky Premium - 1 Device 1 Year - GLOBAL Kaspersky Premium - 1 Device 1 Year - GLOBAL $37.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Microsoft SQL Server 2019 Enterprise Microsoft SQL Server 2019 Enterprise $39.00
  • Windows Server2008 R2 Remote Desktop Services device connections (20)cal Windows Server2008 R2 Remote Desktop Services device connections (20)cal $29.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.