Protect Excel Cells in a worksheet

This post is regarding the query, that how can user protect some of the cells in a worksheet for editing.

Steps to do this as follow:


Default when you protect your worksheet it lock all the cells for editing, but in case if you want some of the cells can be edited by user then, for that you have to make that cells unlock. But how can we do that?

Answer is,

• On the Format menu, click Cells, and then click the Protection tab.
• Click to clear the Locked check box and click OK.

                               Or

                        Press Ctrl + 1

• On the Tools menu, point to Protection, and then click Protect Sheet. Type a password if you want one, and then click OK.

Done !!!



NOTE: If you lock a cell and protect the worksheet, then you cannot type data into the cell, modify the data currently in the cell, or change other attributes of the cell (such as cell formatting).