3 Methods to Unhide All Sheets in Excel (& how to hide)
Step 1: In Excel ribbon, click File->Info->Check for Issues->Inspect Document. Step 2: Click Yes on pops up message. Step 3: On pops up Document Inspector, click Inspect. Step 4: On current Document Inspector window, drag the scrollbar to the end, verify that Hidden Worksheets is listed, click Remove All.