How to password protect cells in excel 2007

#HOW TO PASSWORD PROTECT CELLS IN EXCEL 2007 PASSWORD#

The easiest way to do this is to click the icon at the end of this field to go to the worksheet and choose your cells. Where it says 'Refers to cells', choose the cell range.For example, if you are designating this area for a specific person, type their name. For a Title, I recommend typing something meaningful so it will be easy to keep track of the cell ranges. Click the New button to designate a new area.

#HOW TO PASSWORD PROTECT CELLS IN EXCEL 2007 PASSWORD#

Now, you will create a different password for each editable area. In the Review tab, choose Allow Users to Edit Ranges. If you are sharing a file with several people and they each have their own area to edit, you may want to assign different passwords to different areas in order to prevent them from accidentally editing an area that isn't theirs. Ranges with Passwords When to use: You're sending out a file to many people, each responsible for specific cell ranges You don't need to select and unlock cells again, you just need to protect the sheet. Remember to protect the sheet again before sending it out. If you need to change a locked area in the future, click on the Unprotect Sheet option in the Review tab and enter your password. Try clicking on a locked area and then on an unlocked area. The result will be that people won't even be able to CLICK in your locked areas, making it easier for them to edit without stumbling into the locked cells. I recommend unchecking the 'select locked cells' option. From the Review tab, choose Protect Sheet. The cells we just unlocked will remain editable, but the rest of the sheet will be locked. Now we are going to password protect our entire worksheet.Go to the Protection tab and uncheck Locked. Right click on any one of the selected cells and choose Format Cells.If you need to select a cell that is not adjacent to the other cells, hold down the control key and click on it. To select adjacent cells, just click and drag. Select the cells that you want people to be able to change.As a result, others will be able to easily enter data into the cells you selected, but will not be able to alter the rest of the cells without a password. This will prevent them from accidentally erasing a formula or replacing important content.ДЄn overview of the process: You will select and unlock the cells that you want to be editable, and then protect the entire worksheet. If you're sending out an Excel file to people who are supposed to fill in information, your best option might be to selectively unlock the cells that they're supposed to edit, leaving the rest locked. Locking / Unlocking Specific Cells When to use: You are sending out the file for others to complete When protecting an entire sheet, it makes sense to leave these options as is. Remember the password, because you are going to need it if you want to edit the worksheet yourself. Click on the Review tab and choose Protect Sheet.People will still be able to open and view your file, they just will be asked for a password if they try to make changes in a protected area. Note that this is different from password protecting your entire file. Protecting a worksheet or cell range can save you a lot of headaches. When you share Excel files with others, it's possible for someone to accidentally delete a formula or replace a cell's content. Protect a Worksheet When to use: You are sharing the file and want others to view, but not edit, a worksheet If you check the 'Read Only Recommended' checkbox, anyone who opens your file will be asked to save a copy instead of replacing your original file. Here, you can specify two passwords - one to open the file, and another to make changes to the file.Click the Tools menu at the bottom of the Save As window and choose General Options.From the Office button, choose Save As.To prevent your file from being opened without a password: As mentioned above, Excel security is not foolproof, but a password may deter someone who has accidentally stumbled upon your file. If you're working with confidential data, you might want to password protect your entire Excel file. Protect a File When to use: You are working with confidential data A phone call is a safer way to communicate the password. However, some of these options will make it easier to collaborate with others on Excel documents, and avoid accidental data tampering.Дo not email passwords with your Excel documents. It's possible, and not very difficult, to get past Excel's password protection. Please note that none of this security is foolproof.

How to password protect cells in excel 2007