- 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.
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.