The button will have a dark background if the selection is locked. Locking a Single Cell in Excel 2010 Many people select the option of locking their entire workbook or worksheet, which is a much more thorough way of locking down the data in your Excel file. It is also used to store the data of banking sector customers and to update all those data regularly. More information about the worksheet elements Clear this check box To prevent users from Select locked cells Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. Thanks again and have a nice weekend! For columns a downward arrow and for the row, a rightward arrow will come up.
Step 7: Click the Protect Sheet option at the bottom of the menu. Whenever someone tries to open the document, Excel prompts them for a password first. But my problem is I can entry the unprotected cell but I can not format that unprotected cell such as font colour,size etc unless un-protect the sheet. The unlocked editable cells are white. Being used by 110,000 elites and 300+ well-known companies.
Further, in the Format cells dialog box, click on Protection Tab. In this article, we learn about how you can lock cells in excel sheet. This method of selecting the cells you want to stay unlocked and then locking the sheet works better. To set it up, open your Excel file and head to the File menu. Enter the password you gave earlier to protect it. After you finalize an Excel 2010 worksheet by reviewing formulas and proofing text, you should consider protecting cells in the worksheet to guard against any unplanned changes. Format rows Using any of the row formatting commands, including changing row height or hiding rows Home tab, Cells group, Format button.
There will be instances when you want to lock specific cells from editing. This is still a limitation of Excel and the only way around it that I know of is to use a macro to add the rows and copy the formulas down. How to unlock certain cells on a protected Excel sheet In the first section of this tutorial, we discussed so that no one even yourself can edit those cells without unprotecting the sheet. This will lock the cells expect the specified cells you just selected in Step 1. You can unprotect the sheet in the same way that you protected it, by right-clicking on the sheet tab.
Click the Arrow at the upper-left corner of worksheet to select all cells in active worksheet. Then go to lock the select cells. Note that Password protects your sheet effectively. Just the way we wanted it. In such a condition, it can be very difficult for you.
It will hide the formulas Now when you protect the worksheet, it will hide all the formulas where you have ticked this box. As a result, if you want to lock a cell, you have to unlock all cells first, lock a cell, and then protect the sheet. A warning box saying This action will save the workbook. Tip from the Experts If you want to quickly or immediately, lock or unlock cells in an Excel spreadsheet, without going through the complete procedure of locking and unlocking, the following shortcut can be adopted. This will bring up the Format Cells window keyboard shortcut for this window is Ctrl + 1. If you have multiple cells selected, the active cell is the cell you selected first and appears with no fill shading.
That is why, in order to lock certain cells in Excel, you need to unlock all cells first. Do you want to continue? I earn a small commission if you buy any products using my affiliate links to Amazon. If you typed a password in Step 3, Excel opens the Confirm Password dialog box. Add a button for locking cells to the Quick Access Toolbar This allows you to quickly see the locked setting for a cell or range. In this case, you can set up permissions for specific users to edit some ranges or individual cells without password. But if the protected sheet has external links to other sheets or workbooks, you need to add those links manually.
To do this, click the Permissions… button in the lower left corner of the New Range dialog and follow steps 3 - 5. To remove worksheet protection, click the Unprotect Sheet button in the Changes group on the Review tab. However, the silver lining is: The locked cells can be selected altogether, but and their inability to get edited or formatted can be changed in protection options. It's important to note that all cells can be edited when the sheet is unprotected. Or, simply type the user name as it is stored on your domain, and click the Check Names button to verify the name. Step 5: Click the Home tab at the top of the window.