![]() Step 4: Locate to the tool menu > choose Review > select Protect Sheet. Step 3: Select the cells that you plan to lock and right-click them to choose Format Cells and tick the Locked option in the Protection window. Step 2: Switch to the Protection interface, untick the Locked option and click OK. Then right-click the worksheet and choose Format Cells in the context menu. Step 1: Press Ctrl+A to select all the cells in the Excel worksheet. And the locked cells only can be changed after entering the correct password for unprotecting the entire sheet. You can use this way when you need others to fill in your Excel worksheet, but want to keep some items like the form title be unchangeable. ![]() Lock Selected Cells with the Common Sheet Password ![]() ![]() Lock Certain Cells Using the Extra Range Passwordġ.Lock Selected Cells with the Common Sheet Password.So, what can you at this time? Here, we will talk about 2 useful ways to lock the selected cells in Excel 2016/2013/2010, let’s continue reading for more details. If you just want the certain cells to be locked, simply password protecting the worksheet can’t be applied. However, this way will lock all the cells in your worksheet. When you need to share an Excel worksheet with others, you might set a password to protect your worksheet from edit or modification.
0 Comments
Leave a Reply. |