How to Lock or Unlock Cell, Column or Row in Excel

Topic: File Encryption & Decryption Product: Microsoft Excel Related Articles: extjs 4.1 unlock activate column qtp excel unlock c# protect column

It is usually occurs to me that we need to lock our cells, columns or rows of our excel files to prevent others' modification. Since I am a neophyte, I can't find a way to do this. So please tell me whether and how can I do this with Microsoft Excel 2007.

sponsored ads

Solution

Launch your Microsoft Excel and Open the file you want to lock.
Select cells, columns and rows and then click format->format cells in Home ribbon.
In protection tab, check Locked option. If you want to hide your formula, you can also check hidden. Then click Ok.
Click Format->Protect Sheet.
You need to type in a password to unptotect this worksheet and set allowed actions to this sheet. Click Ok after that.

You need to confirm the password.
Now your excel cells has been locked and password-protected. If others want to edit it, There will be a warning saying that this cell is read-only and cannot be editted.

Tips

If you want to unlock them, you can click Format->Unprotect sheet and then type in your unprotect password. Afer that, your sheet can be edited again

How to Insert Column or Row in Excel

Excel offers an easy way to insert column or row into a workbook. The steps below will show you how to insert column or row in Excel.

How to Freeze Column or Row in Excel

You may want some rows or columns to stay a fixed position when you observe other cell values, especially your worksheet contains a large number of content. For example, if the top row or column show titles, and you want to know the titles when you scroll down or right. Now you can freeze column or row in Excel to solve the problem. Steps are as follows:

Search for Related Topics

row hidden excel dengan vb6 lock row visible excel c# hide rows columns excel multi row cell excel npoi c# unshare rows columns excel page auto group rows count excel display row cell excel

Related Unresolved Questions