Library Technology – Reviews, Tips, Giveaways, Freeware

Excel 2010 tips: How to protect your Excel 2010 spreadsheet

Posted In MS office - By Techtiplib on Wednesday, April 18th, 2012 With No Comments »

To protect your Excel 2010 spreadsheet, you should follow these steps:

  1. In an open spreadsheet, click the File tab. The Backstage view opens.
  2. In the Backstage view, click Info.
  3. In Permissions, click Protect Workbook. Then select actions below:
Protect excel
– Mark as Final: Make the document read-only

When a spreadsheet is marked as final, typing, editing commands, and proofing marks are disabled or turned off and the spreadsheet becomes read-only. The Mark Comment as Final command helps you communicate that you are sharing a completed version of a spreadsheet. It also helps prevent reviewers or readers from making inadvertent changes to the spreadsheet. 

– Encrypt with Password: Set a password for the document
When you select Encrypt with Password, the Encrypt Document dialog appears. In the Password box, type a password. Important: Microsoft cannot retrieve lost or forgotten passwords, so keep a list of your passwords and corresponding file names in a safe place.
– Protect Current Sheet: Protect the worksheet and locked cells
By using the Protect Current Sheet feature, you can select password protection and allow or disallow other users to select, format, insert, delete, sort or edit areas of the spreadsheet.
– Protect Workbook Structure: Protect the structure of the worksheet
By using the Protect Workbook Structure feature, you can select password protection and select options to prevent users from changing, moving, deleting important data.
– Restrict Permission by People: Install Window Rights Management to restrict permissions
Use a Windows Live ID or a Microsoft Windows account to restrict permissions. You can apply permissions via a template that is used by your organization, or you can add permissions by clicking Restrict Access.
– Add a Digital Signature: Add a visible or invisible digital signature

Digital signatures authenticate digital information such as documents, e-mail messages, and macros by using computer cryptography. Digital signatures are created by typing a signature or by using an image of a signature to establish authenticity, integrity, and non-repudiation. See the link at the end of this topic to learn more about digital signatures.

About -

Hey, this blog belongs to me! I am the founder of TechTipLib and managing editor right now. And I love to hear what do you think about this article, leave comment below! Thank you so much…