How to Hide Formula in Excel 2007, 2010 & 2013

This tutorial will explain you how to hide formula in Excel 2007, 2010 & 2013 (Step by Step instructions with captured snapshot).

Steps for hiding formula in 2007, 2010 & 2013 are same, so we have taken the example of Microsoft Excel 2007.


Open Microsoft Excel > Type any formula as shown in below snapshot.

Hide formula in Excel - Formula Entered


To hide formulas, first you need to unlock all of the cells on your Excel sheet. You can do this by selecting all of the rows and columns in your sheet. Right click on selected rows and columns then choose Format Cells option from the popup menu.

Hide formula in Excel - Format Cells

Once you click on Format Cells option following popup window will appear, Now uncheck Locked option under protection tab, click on OK button.

Hide formula in Excel - Uncheck Locked


Next, select the cells that you want to hide formulas for. Right click and then select Format Cells from the popup menu.

Hide formula in Excel - Single Format Cells

Now check Hidden option under protection tab, click on OK button.

Hide formula in Excel - Hidden


Now to hide the formulas for selected cells, you must also protect the worksheet. To do this, select Review tab in the toolbar and click on Protect Sheet button. A popup windows of Password will appear, Enter password & confirm password.

Hide formula in Excel - Protect Sheet

By this way you can hide formulas in Excel 2007. All the above steps will be same in all other versions of Microsoft Excel 2010 & 2013. You can see the below snapshot to verify that the formula is hidden for the selected cells.

Hide formula in Excel

Subscribe to get free tech advice, tips and in-depth articles.

Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.

Leave a Reply

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