Part 1: How to hide formulas and comments in Excel
In life and at work, there are always hidden things that we want to hide, want to keep secrets from the eyes of others.In Excel, too, there will come a time when you want to hide a formula to hide the profession;a photo, a comment that does not want others to know;or even hide the whole sheet or entire Excel file so that no one can find it.The problem is how to do it, you do not need to worry, becauseTipsMakewill guide you all the types of data hiding in Excel in a specific, clear and most detailed way.
The followingTipsMakewould 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 want 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 want 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 on ' 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. Tipsmakewish you success and see you in the following sections, promising many interesting things.