Hide Or Unhide Worksheets. Right-click on any of the existing tabs. Lets say you want to hide the Sheet1 from the active workbook.

Right-click on any of the existing tabs. Click on a sheet hold down the control or the shift key click on the other sheets youd like to hide right-mouse click and select Hide. Select Format in the Cells group.
4 Zeilen To unhide worksheets follow the same steps but select Unhide.
Anzeige Download over 20000 K-7 worksheets covering math reading social studies and more. This makes the process of unhiding multiple sheets really fast. How to Hide 1. To Unhide a single Worksheet in Excel using VBA we need to use open the Visual Basic Editor.