how do I password protect an excel sheet?

[christinaNnyc]

Hello,
I'm trying to protect an excel sheet so no one can open it without a password. Can someone help?
Thank you!

 

[JE McGimpsey]

I'm trying to protect an excel sheet so no one can open it without a
password. Can someone help?

You can use Tools/Protection/Protect Sheet..., but be aware that there
is NO way to protect a sheet so that "no one can open it".

XL's internal protection is suitable for distributing to very honest (or
lazy) novices, but can be bypassed in about 30 seconds:

http://www.mcgimpsey.com/excel/removepwords.html

And workbook protection doesn't take much longer:

http://www.mcgimpsey.com/excel/fileandvbapwords.html

The only really secure way to protect a workbook is to create it as a
COM add-in. Unfortunately, that capability doesn't exist on the Mac.