How To Hide And Unhide Sheets In Excel. In the menu click the hide option to hide the selected worksheet. Open your workbook and hold alt f11 keys to open the microsoft visual basic for applications window.
Press alt f11 to open the visual basic editor. On the home tab in the cells group click format visibility hide unhide hide sheet. One of the easiest methods is to select a sheet or select multiple sheets using standard windows ctrl and shift selection techniques right click the sheet tab then select hide.
Or right click the worksheet tab and choose hide option you could hide single one sheet.
Similarly you can unhide sheets in excel by right clicking on any active or visible worksheet and this time selecting the unhide option in the right click menu. Press and hold down the ctrl key on. In the menu click the hide option to hide the selected worksheet. Right click on any of the existing tabs.
