How to 'cover up' Data in a Cell in Excel2007

[JARHTMD]

I have a sheet in which I want to deliberately "cover up" data in a particular cell. I don't want to hide the cell. I want it to be readily/quickly available (for me), but hidden from everyone else. I don't want anything elaborate. I'll know what's there, but others will have no reason to even suspect that anything is stored there.

Left-Justified literals that are too wide for a column will overflow into the next cell(s) to the right, IF those cells are empty. Is there a way to cause that overflow, even if they contain data?

 

[SpillerBD]

how hidden are you hoping for? Security level?
And what kind of data is in the cell? If it is a reference for formulas, there are other places to store it.

 

[Rick Rothstein]

I have a sheet in which I want to deliberately "cover up" data in a particular cell. I don't want to hide the cell. I want it to be readily/quickly available (for me), but hidden from everyone else. I don't want anything elaborate. I'll know what's there, but others will have no reason to even suspect that anything is stored there.

Left-Justified literals that are too wide for a column will overflow into the next cell(s) to the right, IF those cells are empty. Is there a way to cause that overflow, even if they contain data?

One possibility... custom format the cell using ;;; (three semi-colons)... the cell will appear blank, but if you select the cell, its contents or formula will appear in the Formula Bar.

 

[JARHTMD]

One possibility... custom format the cell using ;;; (three semi-colons)... the cell will appear blank, but if you select the cell, its contents or formula will appear in the Formula Bar.

Thanks, Rick. That's what I was looking for.