How to All Types of Data Hiding in Excel Are Extremely

Part 1: How to Hide Formulas and Comments in Excel

The following TipsMake would like to use the version of Excel 2007 to guide you. As long as you understand the nature, we believe that you will be able to apply it to all different versions of Excel. The article will be divided into several parts, in this part, Accountant Duc Minh will show you how to hide formulas and comments.

1) Hide Formulas in Excel

Let us give you an example where you may need to hide the formula in cell C13 as shown below:

- Step 1: You select a cell (cell) or cells to hide the formula, in this case cell C13, then go to 'Format Cells'. There are two ways: press 'Ctrl + 1' or right click and select 'Format Cells'. - Step 2: Go to 'Protection' and tick the 'Hidden' checkbox if it is not already ticked.

- Step 3: Go to the ' Review ' tab -> select the ' Protect Sheet ' item in the ' Changes ' group, a ' Protect Sheet ' dialog box will appear, enter the password to be protected in the ' Password to unprotect sheet ' text box. Then click ' OK ' and re-enter that password into the ' Reenter password to proceed ' text box -> ' OK '.

Now, when you select cell C13 to see it you won't be able to see the formula anymore, but the value in cell C13 as ' trip 2 ' still exists. So you have succeeded.

2) Hide Comments in Excel

By default, when you create a comment in Excel, any cell with a comment will show a red triangle in the top right corner of the cell. And when you hover over or select the box, those comments will appear.

Now TipsMake would like to give an example of you may need to hide a rather sensitive comment ' She is my lover! 'about an image in Excel as shown below:

So you need to follow these steps: - Step 1: Left-click the Microsoft Office Button (the icon in the top left corner of Excel 2007), then select 'Excel Options' (In Excel 2010 and Excel 2013 go to File -> Options).

- Step 2: Choose ' Advanced ' -> scroll down to find ' Display ', then left click ' No comments or indicators ', then click ' OK '

-> And here is the result:

* Note: Comments will only appear once you turn on the ' Show All Comments ' mode in the Review tab.

Part 1: How to hide formulas and comments in Excel, this series of articles about hiding data types in Excel is over. Tipsmake wish you success and see you in the following sections, promising many interesting things.