- 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.
Instructions on all types of data hiding in Excel are extremely useful Picture 2
- 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 '.
Instructions on all types of data hiding in Excel are extremely useful Picture 3
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.
Instructions on all types of data hiding in Excel are extremely useful Picture 4
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:
Instructions on all types of data hiding in Excel are extremely useful Picture 5
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).
Instructions on all types of data hiding in Excel are extremely useful Picture 6
- Step 2: Choose ' Advanced ' -> scroll down to find ' Display ', then left click on ' No comments or indicators ', then click ' OK '
Instructions on all types of data hiding in Excel are extremely useful Picture 7
-> And here is the result:
Instructions on all types of data hiding in Excel are extremely useful Picture 8
* 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.