Right-click the sheet tab you want to hide
Click Hide
To hide multiple sheets, select the sheet tabs first, then right-click and click Hide
To hide a sheet through the ribbon, go to the View tab
Click Hide in the Window group
To unhide a sheet, right-click any sheet tab and click Unhide
Select the sheet you want to restore and click OK
To hide a sheet with VBA, open the Visual Basic Editor
Insert or use a macro that sets the sheet’s Visible property to xlSheetHidden or xlSheetVeryHidden
Save the workbook as a macro-enabled file if using VBA