Enter a password in the blank box in the popping up Protect Sheet dialog box, and click the OK button. Click Review > Protect Sheet to protect current worksheet. In the Format Cells dialog box, check the Lock option under Protection tab, and click OK button. Select cells and ranges that you want to lock, right click and select the Format Cell item from the context menu.ĥ. In the Format Cells dialog box, uncheck the Locked option under Protection tab, and click OK button. Right click any selected cell, and select the Format Cell item from the context menu. Click the Arrow at the upper-left corner of worksheet to select all cells in active worksheet.Ģ. The following steps will guide you to unlock all cells in current firstly, lock required cells and ranges, and then protect current worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |