• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Hide worksheet formula in Excel 2013 & Excel 2010

July 26, 2015 by Admin Leave a Comment

Excel 2013 and Excel 2010 allow users to hide formula used in a Worksheet. You can use this feature when you want to prevent any one from accidentally changing the entered formula.

Let us say you want to hide the formula (=SUM(F5:F8)) which has been used in the bellow example.

image

Select the cell where the formula has been entered and navigate to Format menu and click the Format Cell menu option (You can also right click and select Format Cell in the Context menu).

In the Format Cell window, navigate to Protection tab and tick the checkbox with Label as Hidden. Click the Ok button to save the changes.

image

Then right click on the Sheet and select Protect Sheet from the list of available menu option.

image

In the Protect Sheet window, tick the check box with label as Protect worksheet and contents of locked cells.

image

If you want to just hide formula then it is not needed to password protect the sheet. Click Ok button to save the changes.

Now when you navigate to the Formula Cell, the formula bar will not displayed any information.

image

Bu this you can prevent excel users from seeing formula used in the worksheet.

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Excel 2010, Format Cell, Formula, Hidden, hide, Protect, Worksheet

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar

Recent Posts

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel

blogmines.com Copyright © 2023