How to hidden a confidential data

Asked By valentino 0 points N/A Posted on - 10/09/2011

When I created a worksheet which consists of confidential data,

I want that these values.although present in the worksheet, it should be hidden and as a result the cells containing this data should appear blank in the worksheet.

How can I do this?

• Status: Open
• Question Views: 1195
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By GordStive 5 points N/A #90252

How to hidden a confidential data

 It is not possible that unprotected worksheets hide confidential data by adding some other data. Nothing reveals that there is displaying some hidden formulas in bars. So blank cells in formula search for these hidden data so link in these cell do nothing. There is also a button which can hide the sheet and also unhide it.  

Find the hidden data in a work sheet by process like these points.

Toggle the worksheet hidden status, open it when clicked, insert rows in worksheet, prevent the referencing hidden worksheet, copy it and rename it, changes tracking of it, Access it, auto select it, record working, hidden check the formulas by macro, working it with displayed message box, macro to delete it, run macro from this sheet, copy it in an existing workbook, make arrow keys on, all workbook must be copying, so please visit it and you will get out of this problem.
 

About GordStive

Questions
0

Answers
28

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 10/09/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #90253

How to hidden a confidential data

In Microsoft Excel the data can be hidden by using many ways.

Method 1

First select the entire columns which include all the data that you want to hide.

Then right click on the selected area and click on the “hide”.

See the below image.

 

Now the data will be hidden as follows.

 

 

However, if you want the cells that contain data should not be hidden but that cells should appear as blank, you can follow the below method.

Method 2

Select the cells which contain the confidential data.

Now click on the font color option in the Font section in the Home tab.

Select the white color and click on that.

 

 

Now the data will not be appeared in the particular columns as follows.

 

 

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/26/2012
• Question Category: MS Excel