How to Hide a Worksheet in Excel (and Unhide It Again)

QUICK ANSWER

Hide or unhide in 2 clicks

What you want	Do this
🙈 Hide one sheet	Right-click the sheet tab → Hide
👁️ Show it again	Right-click any tab → Unhide → select → OK

💡 Good to know: Hiding a sheet does not delete or change any data — it only removes the tab from view.

STEP BY STEP

How to hide a worksheet

Right-click the sheet tab

At the bottom of the window, right-click the tab of the sheet you want to hide.

Choose Hide

In the menu, click Hide. The tab disappears — the sheet is now hidden.

Hide several sheets at once

Hold Ctrl and click each tab you want to hide (or Shift to select a range), then right-click one of them → Hide.

⚠️ At least one sheet must stay visible. Excel will not let you hide the only visible worksheet in a workbook.

BRING IT BACK

How to unhide a worksheet

Right-click any visible sheet tab

Then choose Unhide.

Select the hidden sheet

Pick the sheet from the list and click OK. If several sheets are hidden, select one (or press Ctrl and pick more) and click OK.

✅ Pro Tip: To unhide all sheets at once, select the first and last entries in the Unhide list with Shift, then click OK.

TROUBLESHOOTING

Common problems & fixes

Unhide is grayed out

The workbook has no hidden sheets, or the workbook structure is protected. Go to Review → Unprotect Workbook and try again. See the Unprotect Worksheet guide.

A sheet still won't appear after unhiding

It may be "Very Hidden." Set in VBA, Very Hidden sheets never show in the Unhide list — change them in the VBA Properties window (see FAQ below).

Mac users

Right-click (or Control+click) the sheet tab → Hide. To unhide: Format menu → Sheet → Unhide.

FREQUENTLY ASKED

Frequently Asked Questions

How do I hide a worksheet in Excel?

Right-click the worksheet tab and choose Hide. The sheet disappears from the tab bar but its data is unchanged.

How do I unhide a worksheet in Excel?

Right-click any visible sheet tab, choose Unhide, then select the hidden sheet from the list and click OK.

Why is Unhide grayed out in Excel?

Unhide is grayed out when the workbook contains no hidden sheets, or when the workbook structure is protected. Unprotect the workbook first if needed.

Can I hide multiple worksheets at once?

Yes. Select several sheet tabs with Ctrl+click, then right-click one selected tab and choose Hide. All selected sheets are hidden together.

What is a very hidden worksheet in Excel?

A Very Hidden sheet cannot be unhidden from the ribbon. You set it with xlSheetVeryHidden in the VBA Properties window; it is often used to protect formulas.

QUICK LINKS

Continue Exploring

SOURCES

Sources & References

Written and fact-checked against Microsoft's official Excel documentation.

Hide or unhide worksheets — Microsoft Support

Disclaimer: This guide is for informational purposes only. Last Updated: September 16, 2026.