Lock only certain cells in Excel

  • Hi All,

    I want to lock certain cells in an excel sheet. I tried options under Alignment and and Review (Protect sheet) but they are not working.

    Can anyone help me to sort this out.

    Much thanks!

    1. Select all the cells you don't want to be locked. These will be the specific cells that can be edited even after the sheet is protected.
    2. Right-click on your selection, select Format Cells, and click on the Protection tab. (Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells window go to the Protection tab.)
    3. Uncheck "Locked" (which is checked by default) and click OK.
    4. Go to Review -> Protect Sheet and press OK to protect the sheet. Any cells you didn't unlock under the Format Cells option (step 3 above) will be locked, while the unlocked cells will be editable.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!