Protect Multiple Worksheets at a Time in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstoprotectmultip, kutools
Published: 2020-10-09 12:09:43

---
title: Protect Multiple Worksheets at a Time in Excel Office 365!!
published: true
date: 2020-10-09 07:11:00 UTC
tags: KutoolsExcelTutorial,StepstoProtectMultip,Kutools
canonical_url: https://geekexcel.com/protect-multiple-worksheets-at-a-time-in-excel-office-365/
---

In this tutorial, we will guide you to learn the steps to **Protect Multiple Worksheets at a Time 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.
## Protect Multiple Worksheets at a Time:

**Check this too: ** [Password Protect a Sheet in Excel](https://geekexcel.com/how-to-password-protect-a-sheet-in-excel-office-365/)

To protect multiple spreadsheets simultaneously, follow the below instructions.

- First, you need to [**open the Excel workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) in which you want to protect the sheets.
- Go to the **Kutools Plus Tab, choose** the **Protect Worksheet** option.

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

- It will open the **Protect Worksheet Dialog Box**.
- In that dialog box, you can see the multiple worksheet sheet names, and you need to **check the worksheet names** which you want to be protected.

![Protect Worksheet Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Protect-Worksheet-Dialog-Box.png)<figcaption id="caption-attachment-15502">Protect Worksheet Dialog Box</figcaption>

### Note:

- Only the **unprotected worksheets** will be listed in the **Protect Worksheet** dialog box.

- You need to **click** the **OK** button.
- Now, you can **insert** a **password** in the **Protect Worksheet Dialog box**.
- In the “ **Allow all users of this worksheet to** ” section, you need to check the options which you want to allow users to do with these protected worksheets.

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

- At last, **click** the **OK** button to protect the worksheets.

### Note:

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

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

## Summary:

In this tutorial, you can easily understand the steps to **Protect Multiple Worksheets at a Time in Excel Office 365** using **Kutools.** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [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/)