Ways to Password Protect an Excel Spreadsheet. Launch Microsoft Excel. Open the spreadsheet you wish to protect with a password.
Click the "Open" icon from the ribbon, browse to the file and then click the "OK" button. Click the Review tab. Select the "Protect Workbook" icon in the "Changes" section. Make sure the "Structure" box is checked. If you have also set up specific windows within the file, check that box, too. Provide a password in the appropriate text box. Note your Excel password in a secure place. Select the "OK" box when you are done. Open up any ranges you want other users to be able to change. Click and drag to highlight the range and then click "Allow Users to Edit Ranges" in the "Changes Section."Click the "New" button on the pop- up window. Provide a title for the range or accept the default title and check that the range is correct. Enter an Excel password for your users and then click the "OK" button. Add a password to protect your entire workbook and control whether others can open or make changes to it. Protect your file by setting passwords for Open and Modify. Password protect a workbook Excel gives you several ways. How to Password Protect or Encrypt Excel Spreadsheets How to set spreadsheet security in Excel 2002/2003 File security settings in Excel 2002/2003 File encryption is based on 'open password' Set 'advanced' property (Crypto. Excel 2007 offers better file protection options. You can easily encrypt and password protect files created using Microsoft office Excel 2007. Earlier we covered a tool My folder to lock folders and files in windows vista.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2016
Categories |