Here are the steps to unhide a worksheet in Excel: While this method hides the worksheet, it’s extremely easy to unhide these worksheets as well. This will hide all the worksheets at one go. Once selected, right-click on any one of the selected tabs and click on ‘Hide”. PRO TIP: To hide multiple sheets at one go, hold the Control key and then select the sheet tabs (that you want to hide) one by one. This setting remains intact when you save the workbook and reopen it again, or send it to some else. This would instantly hide the worksheet, and you will not see it in the workbook.
Right-click on the sheet tab that you want to hide.
You can use the below steps to hide a worksheet in Excel: Regular Way of Hiding a Worksheet in Excel