How to Hide and Show Sheet in Excel: Step-by-Step Guide

This updated guide explains how to Hide and Show Sheet in Excel through clear steps, practical examples, and important checks that help prevent common errors.

You can perform hiding / showing sheet in the following ways:

Note:

- In Excel file always have to display 1 sheet, so if the Excel file has 1 sheet, you cannot hide that sheet.

- You can hide multiple sheets at once by holding down Ctrl key to select the sheets but do not manipulate multiple sheets at once, want to display multiple sheets at once, you need to install the Add-ins.

Method 1: Hide / Show Sheet from Excel 2007 2010 2013 Toolbar.

1. Hide Sheet

Step 1: Select the sheet to hide.

Step 2: On the toolbar, select Home -> Format -> Hide & Unhide -> Hide Sheet .

Immediately the sheet you selected will be hidden.

2. Show Sheet

Step 1: On the toolbar, select Home -> Format -> Hide & Unhide -> Unhide Sheet .

Note: Only when an Excel file has a hidden sheet does it appear .

Step 2: Appear the Unhide dialog box, select the sheet name you may need to display in the Unhide sheet section and click OK to display the sheet.

Method 2: Hide / Show the Sheet Directly from the Bar Containing the Sheet Name.

1. Hide Sheet

Step 1: Select the sheet to hide.

Step 2: Right-click the selected sheet name, a small menu appears, select Hide to hide the sheet.

2. Show Sheet

Step 1: Right-click any sheet name in Excel file and select Unhide .

Step 2: A Unhide dialog box appears, select the sheet name to appear in the Unhide sheet section and click OK to display the sheet.