back to gallery
how to lock cells in excel
5 steps
1
Select the Cells to Lock
Open your Excel workbook and select the cells you want to lock. You can click and drag to highlight multiple cells.
2
Open Format Cells Menu
Right-click on the selected cells and choose **Format Cells** from the context menu.
3
Go to Protection Tab
In the Format Cells dialog box, click on the **Protection** tab. Here, you will see options for locking and hiding cells.
4
Enable Locked Option
Check the box next to **Locked** to enable locking for the selected cells. Click **OK** to confirm your changes.
5
Protect the Worksheet
Go to the **Review** tab on the ribbon and click on **Protect Sheet**. Set a password if desired and click **OK**. Your selected cells are now locked.
Documents you might like
Copyright © 2024 Notta. All Rights Reserved.