Instructions on all types of data hiding in Excel are extremely useful
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.
You should read it
- Types of data hiding in Excel - Part 2: How to hide cells, overflow text
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to hide and hide sheets in Excel and show them again
- Hide / show the Formula Bar in Excel
- How to hide, show notes in tables on Excel
- Excel with hidden lines - How to hide lines and display hidden lines in Excel
- Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
- Guide to lock, hide and secure files and folders with Hide Folders software
May be interested
- Types of data hiding in Excel - Part 2: How to hide cells, overflow textcontinuing the 'extremely useful guide to all types of data hiding in excel'. tipsmake would like to introduce to you part 2: how to hide cells, overflow text ...
- Types of data hiding in Excel - Hide pictures, graphs, rows, columnstipsmake introduce to you part 3: how to hide photos, graphs, drawings, lines, columns in excel
- Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbooktypes of data hiding in excel - part 4: hide sheet, sheet tab, scroll bar, workbook
- Types of data hiding in Excel - Part end: Hide Excel Filestoday tipsmake will show you the last part: 'hide excel file' in the series 'guide all types of hidden data in excel extremely useful'.
- How to convert Powerpoint files to PDF, Wordin the course of manipulating powerpoint, you have or have encountered a situation that you want to convert powerpoint files to word and pdf files. do not worry we will help you solve that problem.
- How to Create a signature for Gmail and insert photos, links, Anchor Text into Gmail signaturestipsmake will show you how to create a signature for gmail and insert photos, links, anchor text into gmail signatures very detailed, specific and extremely useful, useful, not to be missed.