Whatever the reason, you can easily lock only certain cells in Microsoft Excel. Then all the cells get locked as you required. Technically this method involves protecting a worksheet and then allowing certain cells to be exempt from that protection. You can encrypt it with a password to limit who can even open it. Commenting privileges may be curtailed if inappropriate images are posted.
If so, then you should never use these techniques to protect really private data. For instance, you might rethink how your data is put together and, perhaps, move the contents of columns E and J to another worksheet or even to another workbook. If they supply the correct password this is the one that you specified in steps 17 and 19 , then they can edit anything they want in columns E and J. If you want to allow others to add or change data in only certain parts of the worksheet, you can unprotect specific ranges of cells. Kutools For Excel brings 300+ advanced features Combine workbooks, sum by color, split cell contents, convert date, and so on. If someone knows the password you used in step 15, however, they can unprotect the worksheet the proper control is on the Review tab of the ribbon and make any changes they want. A third approach is to use a tool introduced with the release of Excel 2010.
Not the answer you're looking for? The workbook has only a single worksheet, and she needs to protect columns E and J so they cannot be changed, unless the user knows a particular password. You may enter a password to protect the sheet if you wish. Select cells and ranges that you want to lock, right click and select the Format Cell item from the context menu. To do this, select all of the rows and columns in your sheet. The title isn't particularly important.
My company has switched from Google Docs to SharePoint and Office 365. Step 2: Select the Review tab and then click on the Protect Sheet. Mary Lou wonders if there is a way she can password protect certain columns in a shared workbook. Next, select the cell s that you wish to protect. Encrypt a Workbook with a Password For the best protection, you can encrypt the file with a password.
This should not be the same password you used in step 17 and step 19; it should be different. Excel displays the Format Cells dialog box. Then a dialog box is popping up to tell you how many cells have been unlocked, please close this dialog box. This protects the cells that are currently selected. Now, this post will show you how to do this. However, the workbook wound need a way to decrypt it every time it is needed to calculate a worksheet.
Your worksheet is now protected. Only allow changes to certain cells with Kutools for Excel The Design tab of Kutools for Excel gathers the unlock cells and the protect sheet utilities. The range now appears in the Allow Users to Edit Ranges dialog box. The advantage to this approach is that you have two levels of —one for the range columns E and J and one for the worksheet as a whole. Free upgrade and support for 2 years.
For information that is truly private, it has no business in a spreadsheet. There are non-traditional ways you can use, as well. Enter your password into the Protect Sheet dialog box, and confirm this password in the Conform Password dialog box. Note that you can lock a worksheet first and then select the cells you want to unlock, but Excel can be a little flaky about that. Protect a Worksheet from Editing You can also protect individual worksheets from editing.
But Excel protects all cells in the worksheet by default whenever you set protections, so we need to turn that off in order to only protect individual cells. First, you need to unprotect the entire worksheet. If they don't, then the next time the workbook is open, the worksheet remains unprotected and anyone can change the contents of columns E and J. Protect an Entire Workbook from Editing You have three choices when it comes to protecting an entire Excel workbook: encrypt the workbook with a password, make the workbook read-only, or protect just the structure of a workbook. That said, I have a couple of workbooks that contain sensitive information, but the entire workbooks are encrypted, the key is known only to me, and it isn't written down anywhere. Please do as follows: 1. See screenshot: Then a dialog box comes out to tell you selected cells have been unlocked.
You can simplify the steps with these two utilities under one tab. This method of selecting the cells you want to stay unlocked and then locking the sheet works better. Excel displays the Protect Sheet dialog box. Up to three images may be included in a comment. Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel 1.
For the locking of the cells to take effect, you must also protect the worksheet. This protects the cells that are currently selected. By default, it allows all users to select the locked and unlocked cells, but you can change this based on your own needs. Unlocking will take effect after you protect the worksheet. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 on this site the. If you want to have a free trial of this utility, please go to first, and then go to apply the operation according above steps.