not sure if what you want, but can try columns or rows, by selecting whole
col/rows, right click on area and select hide.

else can change text color to match background, thereby making data invisible.
use of conditional format to hide selected cells can also be used. have a
fixed cell to manipulate on/off, e.g.: in cell (put cursor in cell
desired) for cond. format:
Format, Cond. Format, change condition to "formula is", enter:

=$A$2="x" (cell has an x makes cond. format active), select color of text
you want...

"duckie" wrote:

how do you hide 1 cell so people can't see whats in it