hiding specific cells

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?
 
M

mikebres

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
G

Gord Dibben

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
 
F

FSt1

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
 
Top