Try the Excel Course for Free!

Workbook Protection in Excel- Tutorial

/ / Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Workbook Protection in Excel- Tutorial: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.

Workbook Protection in Excel- Tutorial

            When you apply workbook protection in Excel, you prevent changes to the workbook’s structure and its windows. Applying the windows workbook protection prevents people from changing the size or shape of the workbook window. Applying structural workbook protection prevents people from adding, deleting, hiding or moving worksheets within the workbook.

            When you apply workbook protection, you can protect either or both the “Windows” and “Structure” in a workbook. You can also provide an optional password that is required to be entered before the workbook can be unprotected. This option is also a bit risky. This is because if you forget the password, you will not be able to remove the workbook protection.

            To apply workbook protection in Excel, click the “Protect Workbook” button in the “Changes” button group on the “Review” tab in the Ribbon. This will launch the “Protect Workbook” dialog box. Check the boxes for the objects that you want to protect, and enter a password, if desired. Then click “OK” when you are finished. If you entered a password, you need to re-enter it into the “Confirm Password” dialog box that appears and then click the “OK” button.

Workbook Protection in Excel- Tutorial: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.

Workbook Protection in Excel- Tutorial: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.

            To remove workbook protection in Excel, click the “Protect Workbook” button in the “Changes” button group on the “Review” tab in the Ribbon to toggle workbook protection off. If an associated password exists, enter it into the “Unprotect Workbook” dialog box that appears, and then click the “OK” button.

Workbook Protection in Excel- Instructions

  1. To apply workbook protection in Excel, open the workbook to protect.
  2. Then click the “Protect Workbook” button in the “Changes” button group on the “Review” tab in the Ribbon.
  3. Select which properties of the workbook to protect by checking the checkboxes for “Structure” and/or “Windows.”
  4. Enter a password for the workbook that you will need to enter to unprotect the workbook, if you like.
  5. Click “OK.”
  6. Re-enter the password, if you opted to enter a password, and click “OK.”
  7. To remove workbook protection in Excel, click the “Protect Workbook” button in the “Changes” group on the “Review” tab in the Ribbon to toggle workbook protection back off.
  8. If an associated password exists, enter it into the “Unprotect Workbook” dialog box and then click “OK.”

Workbook Protection in Excel- Video Lesson

            The following video lesson, titled “Workbook Protection,” shows you how to apply and remove workbook protection in Excel. This video lesson is from our complete Excel training, titled “Mastering Excel Made Easy v.2016-2013.”

TOP
Sale!    $49 All-Access! 0 Days 10 Hours 17 Minutes 53 Seconds      $199$49 Access to Entire Library!
See Deals