Slider

How to Lock Specific Cells in Excel to Protect the Data

Date:2019-7-16 Author:Cordelia

When we are editing a table with Excel, some of the data in it may be so important that can't be modified by others freely or by ourselves incautiously. If we can lock one or several cells in the table only, we can then focus more on processing the data without extra worries.

How to Lock Specific Cells in Excel

1. First, right click the small triangle in the left upper corner of the table and choose Format Cells.

How to Lock Specific Cells in Excel to Protect the Data

2. Uncheck Locked in Protection tab and hit OK.

How to Lock Specific Cells in Excel to Protect the Data

3. Then select the cells you want to lock, right click your mouse and choose Format Cells.

How to Lock Specific Cells in Excel to Protect the Data

4. Switch to Protection tab and check Locked, then hit OK to enable protection.

How to Lock Specific Cells in Excel to Protect the Data

5. Click ReviewProtect Sheet. You can set a password in the textbox and click OK.

How to Lock Specific Cells in Excel to Protect the Data

6. Reenter the password to confirm it.

How to Lock Specific Cells in Excel to Protect the Data

7. Now check your sheet. The cells you locked can't be modified anymore, otherwise a warning window will pop out.

How to Lock Specific Cells in Excel to Protect the Data

8. Meanwhile you can still edit the text in other cells.

How to Lock Specific Cells in Excel to Protect the Data

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

0 thoughts on “How to Lock Specific Cells in Excel to Protect the Data”

  1. Pingback: 4 Tips to Protect Data Security in Paperless Office

Leave a Reply

Your email address will not be published. Required fields are marked *