View Single Post
  #4   Report Post  
bj
 
Posts: n/a
Default

the other responses look good, but for hiding data and text in cells, I
prefer using the custom format ;;; (three semicolons) to hide the items in a
cell. I have had white formated text print as black when I printed a
document black and white only.

"Dharsh" wrote:

Does anyone know if I can password protect a few cells in
a worksheet. I am going to send out my spreadsheet to
people and don't want them to see the contents of certain
cells. I could change the colour of the text to white but
what if someone accidently pick it up! So can I password
protect those cells?

Thanks in advance