Unprotect Multiple Worksheets at Once in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstounprotectmult, kutools
Published: 2020-10-09 12:09:54

---
title: Unprotect Multiple Worksheets at Once in Excel Office 365!!
published: true
date: 2020-10-09 07:12:54 UTC
tags: KutoolsExcelTutorial,StepstoUnprotectMult,Kutools
canonical_url: https://geekexcel.com/unprotect-multiple-worksheets-at-once-in-excel-office-365/
---

In this post, we will learn the steps to **Unprotect Multiple Worksheets at Once in Excel Office 365** using **Kutools.** Let’s jump into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Unprotect Multiple Worksheets at Once:

- You need to [**open the Excel workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that is protected.
- Go to the **Kutools Plus Tab, choose** the **Unprotect Worksheet** option.

![Select the Unprotect Worksheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Unprotect-Worksheet-option.png)<figcaption id="caption-attachment-15509">Select the Unprotect Worksheet option</figcaption>

- It will open the **Unprotect Worksheet Dialog Box**.
- Kindly, **check the worksheets** which you want to unprotect in the list, then **click** the **OK** button.

![Select the worksheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-worksheets.png)<figcaption id="caption-attachment-15510">Select the worksheets</figcaption>

- It will open a prompt box, you need to **enter** the **password** in that.
- After typing the password, you need to **click** the **OK** button.

![Enter the worksheet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Enter-the-worksheet.png)<figcaption id="caption-attachment-15511">Enter the worksheet</figcaption>

- Now, a dialog box will pop out to tell you **how many worksheets have been unprotected** as shown in the below screenshot.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-OK-button.png)<figcaption id="caption-attachment-15512">Click the OK button</figcaption>

### Note:

- If you want to unprotect the worksheet, just **right-click on the sheet tab** in which you want to **protect** and **enter** the **password.**

![Select the Protect Sheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Protect-Sheet-option.png)<figcaption id="caption-attachment-15515">Select the Protect Sheet option</figcaption>

## Conclusion:

In this post, you can clearly understand the steps to **Unprotect Multiple Worksheets at Once in Excel Office 365** using **Kutools. ** Share your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Convert Cell Formulas to Text Strings in Excel](https://geekexcel.com/how-to-convert-cell-formulas-to-text-strings-in-excel-office-365/)
- [Insert Title Rows into a Range in Excel](https://geekexcel.com/insert-title-rows-into-a-range-in-excel-office-365-kutools/)