How to Unhide Sheets in Excel

How to Unhide Sheets in Excel

There are a few ways to unhide sheets in Excel. The easiest way is to right-click on the tab at the bottom of the Excel window and select Unhide from the menu. This will show a list of all the hidden sheets in the workbook. You can then select the sheet you want to unhide and click OK.

Another way to unhide sheets is to use the keyboard shortcut Ctrl+Shift+U. This will open the Unhide dialog box, where you can select the sheet you want to unhide.

Finally, you can use the Excel VBA code to unhide sheets. This code is:

Sheets("Sheet1").Visible = True

Sheets("Sheet2").Visible = True

Sheets("Sheet3").Visible = False

Sheets("Sheet4").Visible = False

Sheets("Sheet5").Visible = False

Sheets("Sheet6").Visible = False

Sheets("Sheet7").Visible = False

Sheets("Sheet8").Visible = False

Sheets("Sheet9").Visible = False

Sheets("Sheet10").Visible = False

Sheets("Sheet11").Visible = False

Sheets("Sheet12").Visible = False

Sheets("Sheet13").Visible = False

Sheets("Sheet14").Visible = False

Sheets("Sheet15").Visible = False

Sheets("Sheet16").Visible = False

Sheets("Sheet17").Visible = False

Sheets("Sheet18").Visible = False

Sheets("Sheet19").Visible = False

Sheets("Sheet20").Visible = False

Sheets("Sheet21").Visible = False

Sheets("Sheet22").Visible = False

Sheets("Sheet23").Visible = False

Sheets("Sheet24").Visible = False

Sheets("Sheet25").Visible = False

Sheets("Sheet26").Visible = False

Sheets("Sheet27").Visible = False

Sheets("Sheet28").Visible = False

Sheets("Sheet29").Visible = False

Sheets("Sheet30").Visible = False

Sheets("Sheet31").Visible = False

Sheets("Sheet32").Visible = False

Sheets("Sheet33").Visible = False

Sheets("Sheet34").Visible = False

Sheets("Sheet35").Visible = False

Sheets("Sheet36").Visible = False

Sheets("Sheet37").Visible = False

Sheets("Sheet38").Visible = False

Sheets("Sheet39").Visible = False

Sheets("Sheet40").Visible = False

Sheets("Sheet41").Visible = False

Sheets("Sheet42").Visible = False

Sheets("Sheet43").Visible = False

Sheets("Sheet44").Visible = False

Sheets("Sheet45").Visible = False

Sheets("Sheet46").Visible = False

Sheets("Sheet47").Visible = False


Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.