Unhide an Excel Sheet or All the Sheets (Worksheet)

- Written by Puneet

excelchamps-free-courses-puneet-gogia

You can quickly unhide the single or multiple sheets in Excel. And this tutorial, we will learn to do this with simple steps.

Unhide a Single Sheet in Excel

  1. First, hover on any of the sheet tabs in your workbook.
  2. Now, right-click and then click on the “Unhide” option.
    1-unhide-an-excel-sheet
  3. After that, from the dialog box, click on the sheet name you want to unhide.
    2-choose-sheetname-to-unhide
  4. In the end, click OK to unhide the sheet.

When you click OK, it will unhide the sheet you selected from the dialog box.

selected-sheet-unhide

Note: You can also use the same “Unhide…” option from Home > Format > Hide & Unhide > Unhide Sheet.

format-hide-unhide-sheets

Unhide All the Hidden Sheets in Excel

Recently, Microsoft updated the option to select multiple sheets from the dialog box to unhide them in one go.

  1. First, right-click on the sheet tab.
  2. Now, in the dialog box, press and hold the Ctrl key.
  3. Next, select multiple sheets or all from the list.
  4. In the end, click OK to unhide the select sheets.
unhide-all-hidden-sheets

Once you click OK, it unhides all the sheets you have selected from the dialog box in one go.

all-sheets-got-unhide
Last Updated: August 10, 2023