Right-click any visible sheet tab
Click Unhide
Select the hidden sheet you want to restore
Click OK
If the Unhide option is unavailable, the workbook may have no hidden sheets or may be protected
To unhide multiple sheets, repeat the Unhide steps for each sheet
To unhide a very hidden sheet, press Alt+F11
In the VBA editor, select the hidden sheet in Project Explorer
In the Properties window, change Visible to xlSheetVisible
Close the VBA editor and return to Excel