How to Quickly Unhide Hidden Formulas in Protected Excel Sheets

Hidden formulas in a protected Excel worksheet can help keep important calculations safe, but they can also make editing, auditing, or updating a template more difficult. If you need to show those formulas again, this guide introduces two easy ways to unhide hidden formulas in protected Excel sheets: one using Excel’s built-in features, and the other using Kutools for Excel for a faster and more convenient workflow.

• What does “Unhide Formulas” mean in Excel?
• Method 1: Unhide formulas with Excel built-in features
• Method 2: Unhide formulas quickly with Kutools for Excel
• Why formulas stay hidden in protected sheets
• Excel vs. Kutools comparison
• FAQs

What does “Unhide Formulas” mean in Excel?

The phrase unhide formulas can mean two different things in Excel:

• Show formulas instead of results in worksheet cells
• Reveal formulas that were hidden in a protected worksheet

In this article, we are focusing on the second case: how to reveal formulas that were hidden by worksheet protection.

When a formula cell is marked as Hidden and the worksheet is protected, Excel displays only the result, not the formula itself. To unhide the formula, you need to remove that hidden setting.

Method 1: Unhide formulas with Excel built-in features

If formulas were hidden using the Hidden cell setting together with worksheet protection, removing sheet protection will make those formulas visible again.

1. Open the worksheet that contains the hidden formulas.

2. Go to the Review tab, and click Unprotect Sheet.

3. If the worksheet is password protected, enter the password to continue.

4. If you want these formulas to remain visible the next time the worksheet is protected, select the formula cells, press Ctrl + 1 to open the Format Cells dialog box, go to the Protection tab, and then clear the Hidden checkbox.

Result: The formulas that were previously hidden by worksheet protection become visible again, and the selected formula cells will remain visible the next time the worksheet is protected.

Method 2: Unhide formulas quickly with Kutools for Excel

If you often work with protected Excel templates, Kutools for Excel provides a faster way to unhide formulas. It helps you quickly identify hidden formula cells with Highlight Hidden, then unhide only the cells you need with Unhide Formulas, without going through Excel’s manual protection settings.

1. Click Kutools Plus > Design View to enable the Kutools Design tab.

2. Click Unprotect Sheet and type in the password to unprotect the sheet.

3. Click Highlight Hidden, then all the hidden formula cells are highlighted with a color.

4. Select the highlighted hidden formula cells you want to unhide, and click Unhide Formulas.

Result: The selected formula cells are quickly switched from hidden to visible, making them easier to review or edit without going through Excel’s manual protection settings.

Why formulas stay hidden in protected sheets

In Excel, formulas do not become hidden just because a worksheet is protected. A formula is hidden only when both of the following conditions are true:

• The formula cell is set to Hidden
• The worksheet is protected

If the worksheet is protected but the formula cells are not marked as Hidden, users can still click the cells and see the formulas in the formula bar.

This is why simply unprotecting the worksheet may make formulas viewable again, but if you want to fully remove the hidden setting for future use, you should also clear the Hidden checkbox from those cells.

Excel vs. Kutools comparison

If you only need to show hidden formulas once, Excel’s built-in method is enough. But for repeated work on protected worksheets, Kutools for Excel is faster and more convenient.

FAQs