hiding specific cells
 

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

hiding specific cells
 

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

"Ashley" wrote:

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

hiding specific cells
 

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


Replace @mailinator.com with @tiscali.co.uk


"mikebres" wrote in message
...
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

"Ashley" wrote:

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

hiding specific cells
 

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


On Fri, 6 Jun 2008 14:59:00 -0700, Ashley
wrote:

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?

hiding specific cells
 

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

"Ashley" wrote:

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