Protecting and Unprotecting Workbooks in Microsoft Excel 2010

In this article, we will learn how we can protect and unprotect workbook in Microsoft Excel 2010 and 2013.

Sometimes to protect our confidential workbook from other users, we secure it through a password when we want to send it somebody else to use the same data we can unprotect it too.

Let’s take an example to understand how we can protect a workbook.

We have sales report. In which some cells contain formula, so we want to protect that cells that contain the formula.
To protect a workbook, follow below given steps:-

  • Go to file tab, in the ribbons.


  • Click on Info option.


  • Click on Protect Workbook.
  • A drop down list will appear.
  • Click on Protect Workbook Structure.


  • Protect structure and windows dialog box will appear.
  • Write the password, click on OK.


  • Re-Enter password dialog box will appear.


  • You have to enter the same password.
  • Click on OK.

To unprotect a workbook follow below given steps:-

  • Go to file tab, in the ribbons.
  • Click on Info option.
  • Click on Protect Workbook.


  • Unprotect dialog box will appear.


  • Enter the password, and click on OK.
  • Sheet will get unprotected.

This is all about how we can protect and then unprotect a workbook in Microsoft Excel.

3 thoughts on “Protecting and Unprotecting Workbooks in Microsoft Excel 2010

  1. I protected sheet 1. Then I copy sheet 1 to sheet 2, sheet 2 is not protected. Anyway that if they copy to sheet 2 is still protecting.

  2. Thank you JR, what I want is if another people copy the sheet 1 (with proctection) and paste to sheet 2, the protection is still on

Leave a Reply

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

− five = 1

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>