Hiding A Cell's Contents / Simple Tricks For Hiding a Data of a Cell / Hide Data in Excel/ Protect Sheet/ Worksheet in Excel

Hiding A Cell's Contents / Simple Tricks For Hiding a Data of a Cell / Hide Data in Excel/ How to hide data cells from printing in Excel?, Protect Sheet / Spreadsheet in Excel.

In Excel sometimes we want to hide data or content of cells. Suppose you have some data / value in your excel spreadshet but you do not want to be displayed or printed, then what you will do for this, perhaps you will store these values / data in some far corner of the worksheet, in a hidden row or column, or even storing them on another worksheet. Here is a question is there only these ways to do so or there is any other simple option or trick, the answer is yes there is a very simple trick to do so.

How to hide a content, data, value of a cell or multiple cells in excel spreadsheet?
How to hide cells from printing in Excel?Here are a some tricks that you may want to try instead.
>> One simple and a very easy is to simply change to font color for those cell to match the background color of your worksheet (Usually it remains white), thereby making the cell contents invisible.

>> The second trick is very good and interesting you certainly like it. So to simply hide the value by applying a special custom number formating code to the cells. Follow the given below steps:

1) Select the cells you wish to hide;

2) Now open Format Cells dialog box (To open Format Cells dialog box you can simply press CTRL+1);

3) Now Go to the Number tab and select Custom from the given Categories;

4) In the Type box (Right ahead the Categories), enter ;;; (three semicolons);

Now what the ;;; (three semicolons ) number formatting code tells to the Excel?
It tells to the Excel that if the cell contents /  data or value are either a positive number, a negative number, a zero value or a text, display nothing.

Note :- But Here a catch, when a cell is selected the contents are visible in the Formula bar, so to hide it permanently or to hide a cells contents in the Formula Bar, you need to protect your sheet. To protect your sheet follow these given steps:

To hide a cells contents in the Formula Bar...

Before going to protect your sheet in excel, you need to change the Hidden property of the cells. 

1) Select the cells you want to hide from the Formula Bar;

2) On the Home tab click Format in the Cells group;

3) Click the Protection tab and place a checkmark in the Hidden property;

4) Go to the Review tab, click Protect Sheet in the changes group, in Protect Sheet dialog box give a password you want to give and check only uppermost two option and leave rest of all unchecked.

Hope this will help you. Please leave your suggestions, feedback in comment box.