|
Hide
Data - MS Excel 2003
Have you ever wanted to hide the
contents of a cell from a reader? For instance, perhaps you have had
formulas referencing a cell containing the current date. This is
when it would be useful from a visual point of view to conceal data
which doesn’t seem to have any relevance to the rest of the
spreadsheet.
To hide cell contents:
-
Select the cell in your
spreadsheet.
-
Click on Format, Cells.
-
Click on Number,
Category, Custom.
-
Enter two double quotes in the
Type box.
-
Click OK.
The value of the cell will not be
visible unless someone clicks on that cell, in which case they will
see the value in the formula bar. If you have put the data in a
cell away from the rest of the data, it is unlikely that a reader
would click on it accidentally.
I hope you’ve found this tip useful. If you liked this one,
subscribe to
receive a tip every month.
Give
yourself time to do what you do best!
|
.jpg)
