How to Make Password Protected Excel File 2007

You can Make Password Protected Excel File in Microsoft Excel 2007. suppose you want to prevent your Excel file cell data to editing or deleting  by other user. It can locked or unlock each cell of your excel sheet. If you will  try to edit or delete cell data then it will prompt error massage ” The cell or chart that you trying to change is Protected and therefore Read-only ” . 

Make Password Protected Excel File

 

1. Open your Excel file in Microsoft Excel 2007 . Click On Review  Tab .


Make Password Protected Excel File








2. Click on Protect sheet, under Review Tab .


Make Password Protected Excel File








After click Protect sheet will be prompt Protect sheet dialog Box .

3. Enter password  in the Password to Unprotect sheet: text Box and then Click Ok .

Make Password Protected Excel File
















4. Now Re -enter password for Confirmation, then Click on OK.

Make Password Protected Excel File

 

Now your Sheet and Cell of Excel has been Protected.

If you will try to Edit or delete cell data then it will be promt these error massage .

Make Password Protected Excel File

 


See Also Video



Related Topics


Share This onShare on FacebookTweet about this on TwitterShare on LinkedInShare on RedditShare on StumbleUponShare on Google+Pin on PinterestBuffer this pageShare on Tumblr
Rakesh Kumar
at
Rakesh Kumar is a Network engineer and a Blogger. He is crazy for learn and write about Technology , Tech and Computer Tips and Tricks Blog.