Microsoft excel 2007 protecting cells

You may enter a password to protect the sheet if you wish. The password is optional. While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. Home MS Excel Cells. Please re-enable javascript in your browser settings. Excel VBA Environ. Share on:.

Please note that none of this security is foolproof. It's possible, and not very difficult, to get past Excel's password protection.

However, some of these options will make it easier to collaborate with others on Excel documents, and avoid accidental data tampering. Do not email passwords with your Excel documents. A phone call is a safer way to communicate the password. If you're working with confidential data, you might want to password protect your entire Excel file.

As mentioned above, Excel security is not foolproof, but a password may deter someone who has accidentally stumbled upon your file. When you share Excel files with others, it's possible for someone to accidentally delete a formula or replace a cell's content. Protecting a worksheet or cell range can save you a lot of headaches. Note that this is different from password protecting your entire file.

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.

To protect a 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.

This will prevent them from accidentally erasing a formula or replacing important content. An overview of the process: You will select and unlock the cells that you want to be editable, and then protect the entire worksheet. 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.

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. Remember to protect the sheet again before sending it out. You don't need to select and unlock cells again, you just need to protect the sheet. 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.

Send us a note about this article. Phone: Email: help brown. For reserved service for a technical consult or a loaner check-out, you can schedule an appointment here.

Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.

About Us Our team. How to lock and protect selected cells from editing in Excel? This article will guide you to lock and protect selected cells or ranges in Excel with following steps: Lock and protect selected cells from editing with modifying cell formatting Lock and protect selected cells from editing with Kutools for Excel Lock and protect selected cells from viewing by encrypting 2 steps Lock and protect selected cells from editing with modifying cell formatting The following steps will guide you to unlock all cells in current firstly, lock required cells and ranges, and then protect current worksheet.

Please do as follows: 1. See below screenshot: 3. See above screenshot: 4. See above screenshot: 6. See below screenshot: 7. Get It Now 1. See screenshot: Then a dialog box comes out to tell you selected cells have been unlocked. Then click the OK button to close the popping up Kutools for Excel dialog box.

You can do as follows: Kutools for Excel - Includes more than handy tools for Excel. Kutools for Excel includes more than handy tools for Excel, free to try without limitation in 30 days.

Download and Free Trial Now! Read More Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished. Thanks - so very very helpful - instant answer to my needs - very grateful this exists. Please i want know lock some of the cells in my worksheet, how do i go about. Hi Daniel, Both the first and the second methods can help and guide you to lock only part of cells in a worksheet. Just follow the tutorial.

Hi, Both of the first method and the second method can protect some certain cells, and make these cells visible but not editable. Thanks Bro thanks i done it Hi, I followed method 1 to the letter along with hiding the cells too. The bold option is greyed out :- Have been through this a couple of times and it is consistent.

I am using Microsoft Office Professional Plus It doesnt matter if I unhide either :- The dialog box re "Protect sheet" always also selects unlocked when I only want to select locked cells, there seems no way around this, what can I do? Is it possible to create a sign-up form in Excel and once a name is entered, that cell locks, and can only be edited by the form administrator? We have encountered some dishonest people who remove others' names and put their own in place of the removed ones.

Just wondering. Excellent step by step instructions.