043 Unhide Sheets in excel إظهار الشيتات
Unhide Sheets in excel
Right-click on any visible sheet tab.
Select Unhide from the menu.
In the Unhide dialog box, select the sheet(s) you want to unhide.
Click OK.
Here are the steps in more detail:
If you can't see the sheet tabs, make sure that the Show sheet tabs option is enabled.
To do this, go to File > Options > Advanced and check the box next to Show sheet tabs.
----------------------------
Right-click on any visible sheet tab.
In the menu that appears, select Unhide.
In the Unhide dialog box, select the sheet(s) you want to unhide. You can select multiple sheets by holding down the Ctrl key while you click on their tabs.
Click OK.
The selected sheets will be unhidden and their tabs will appear in the workbook.
Here are some additional things to keep in mind when unhiding sheets in Excel:
You can also unhide sheets by using the keyboard shortcut Ctrl+Shift+H.
If you want to unhide all hidden sheets at once, you can use the keyboard shortcut Ctrl+`` (that is, the spacebar).
If you have hidden a sheet using the Very Hidden option,
you will need to use VBA code to unhide it.
Sub UnHide()
Dim sheet As Worksheet
For Each sheet In Worksheets
sheet.Visible = True
Next
End Sub