How to Hide Or Unhide Formulas When Protecting A Worksheet in Excel?
Tags: hideorunhideformulas, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:31:14

---
title: How to Hide Or Unhide Formulas When Protecting A Worksheet in Excel?
published: true
date: 2020-11-15 15:44:18 UTC
tags: HideOrUnhideFormulas,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-hide-or-unhide-formulas-when-protecting-a-worksheet-in-excel/
---

In this article, you will understand the steps to **Hide Or Unhide Formulas When Protecting A Worksheet in Excel Office 365** using **Kutools.** Let’s get 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.
## Hide Formulas when Worksheet is Protected:

To hide formulas when your worksheet is protected, do as follows.

- On the **Kutools Plus Tab, select** the **Worksheet Design** option.

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

- Then, it will display the **Design Tab.**
- Now, you need to **select the formula cells** that you want to hide.

![Formula Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formula-Cells.png)<figcaption id="caption-attachment-17210">Formula Cells</figcaption>

- After that, you need to **click** the **Hide Formulas** option under the **Design Tab,** a **dialog box** will pop-out to tell you that the formulas will be hidden when the worksheet is protected.
- Then, **hit** the **OK** button.

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

- Next, you need to **click** the **Protect Sheet** option to **open** the **Protect Sheet Dialog Box.**
- In that dialog box, you need to **enter** the **password** and **click** the **OK** button.
- Then, the **Confirm Password Dialog box** will be opened, you need to **re-enter** the **password** and **click** the **OK** button.

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

### Note:

- You can also open the **Protect Sheet Dialog Box** by clicking the **Protect Sheet** option under the **Review Tab**.

![Review Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Review-Tab.png)<figcaption id="caption-attachment-17220">Review Tab</figcaption>

- At last, if you select any formula cell to which you applied the **Hide Formulas** feature, then the formula will be hidden as shown in the below screenshot.

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

## Unhide the Formulas when Protecting the Worksheet:

To unhide formulas in the protected worksheet, follow the below steps.

- First, you need to open the worksheet and **select** the **Unprotect Sheet** option under the **Design Tab.**

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

- It will show the **Unprotect Sheet dialog box** , where you need to **enter the password** to unprotect your worksheet.

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

### Highlight Cells with Hidden Formulas:

- You need to **select** the **Highlight Hidden** option under the **Design Tab.**
- Now, you can see that all the hidden formula cells are highlighted with color as shown in the below image.

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

### Unhide Hidden Formulas:

- You need to **select** the **highlighted hidden formula cells** that you want to unhide.
- Then, **select** the **Unhide Formulas** option under the **Design Tab.**
- Kutools for Excel Dialog Box will pop-out to tell you that formulas in the cells have been unhidden.
- **Hit** the **OK** button.

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

- Finally, all the formula cells are unhidden even though the worksheet is protected.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-3.png)<figcaption id="caption-attachment-17218">Output</figcaption>

## Closure:

In the above article, you can clearly learn the steps to **Hide Or Unhide Formulas When Protecting A Worksheet in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Create Custom Lists and Fill Cells with them in Excel 365](https://geekexcel.com/how-to-create-custom-lists-and-fill-cells-with-them-in-excel-365/)
- [Unprotect Multiple Worksheets at Once in Excel Office 365!!](https://geekexcel.com/unprotect-multiple-worksheets-at-once-in-excel-office-365/)