Occasionally, I work on very confidential Excel files, ones that I don't want anyone accessing at all.
And in this post I will show you how I password protect those files, so no one can see the content without my very long password.
This will be short and straight to the point.
Also note that I use Excel 2010.
Open the file you want to password. Go to File.
Click on Encrypt with Password.
A dialog-box will come up.
Enter the password you want to encrypt the file with. You'll do this twice.
Now, whenever you try to open the file, you get a prompt for password first.
And that's how to password protect an Excel File in Office 2010.