HIDE DATA IN EXCEL WORKSHEETS
Sometimes you may need to hide data in a
particular cell in an Excel worksheet. Let’s say you have some data in cell C5
you would like to hide from another viewer. See below;
Click cell C5 to select it, and then click in the small square in the Number section (known as a dialog box launcher). See below:-
Step 1 – When the Format Cells dialog box opens, click the Numbers tab (if necessary)
Step 2 – Select Custom from the Category list.
Step 3 – Now double-click the Type entry box and type three semicolons – ;;;
Step 4 – Click OK to close the dialog box and accept your new formatting. (See below)
At this point, the data in cell C5 disappears. It’s still there and will work in calculations, but it isn’t visible. If you need to check the data, just click the blank cell and the contents appear in the Formula entry box.