How to Protect a Sheet of Microsoft Excel


Sometimes you may reach in situation where you need to protect data in one or more sheets in a file.

This article explains how you can protect some sheets. Here the approach is to make few sheets read only. Consider the following example; in my file I have three sheets. I need to protect sheet 1.How to do it?

Here it’s very simple. Follow the steps:

Open Microsoft Office => Go to HOME => Format => Protect Sheet 


The protect sheet dialogue box will appear. It prompts for entering the password. Enter password here and click ok.Retype password box will appear and here you need to type your password again.



So now our worksheet is password protect. Try entering something in the cells, you will see the following prompt box and excel will not allow you to enter anything. So the worksheet now becomes read only.


But the other sheets in the same file are not protected and you can  continue entering data there.

Unprotect Sheet

You can unprotect the sheet by doing these steps again. Now Instead of Protect you will see unprotect option.

Go to HOME->Format->UnProtect Sheet. 



You will be prompted to enter the password. Enter password and click ok.Your sheet is now unprotected. 


                             


tags:

Excel Password protected, Office Excel Protect Sheet, Protect Excel Sheet, Unprotect Excel Sheet
Microsoft Visual Studio 2022 Promo Code
Latest News
Latest TechTips
Latest Posts
Categories