How do you protect an Excel file?
Monday, September 12th, 2011 at
3:51 pm
You can protected an Excel file with a(n) _____ to prevent it from being changed or even opened.
-digital signature
-PIN
-authentication stamp
-password
Ok so my answer was digital signature and it was wrong…so what is the answer..there is not option as to "lock the cells"…so what would it be? hmm? it doesnt tell you the correct answer by the way so if anyone truly knows that would be great
Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software
Tagged with: authentication • cells • correct answer • digital signature
Filed under: Microsoft Excel
Like this post? Subscribe to my RSS feed and get loads more!
The answer is a Password
Assuming you’re using Excel 2007 or 2010:
To protect an Excel Workbook, hit file (Excel 2010) Office button (Excel 2007)
Then, Save As>Tools>General Options. The tools button is located right next to the save button. It has a little drop down arrow. The drop down menu appears when clicked, then select general options. A dialog box appears with the following options:
A password to open, and an option for a password to modify.
Microsoft Office Excel 2007 offers better file protection options to secure your workbook. You can easily encrypt, password protect and lock your files created using Microsoft Office Excel 2007. By setting a password, unauthorized users are prevented from opening or modifying the document without password.
Now follow this tutorial on how to password protect MS Excel 2007:
http://www.recoverlostpassword.com/article/password-protect-ms-excel-2007.html