hiding specific cells

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

I have an employee spreadsheet that I need to hide the pay amounts for so
that only I can see them by inputting a password. I don't mind if the rest
of the sheet is viewable by others. Is this possible?
 
Use Protection under the Tools menu. You can password the sheet so a user
would need to know the password to make any changes.

Mike
 
Just be warned that Worksheet Prtotection is not very strong and there are
several passwork breakers readily available.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
The general rule is.......................

If you don't want someone to see the data, don't include it in the workbook.

Excel internal security is very weak and passwords easily cracked.


Gord Dibben MS Excel MVP
 
hi
another suggestion is that if the data is necessary to your work then you
might save that file to a flash drive that you can insert and remove quickly.

regards
FSt1
 
Back
Top