How To Hide And Unhide Sheets In Excel. Open your workbook and hold alt f11 keys to open the microsoft visual basic for applications window. To unhide a worksheet follow the same steps but select unhide.
Normally you can use the veryhidden function to hide the worksheets first and then set a password for them please do as following steps. All that is required to hide a worksheet in excel is to right click on the worksheet that you want to hide and select hide optionin the right click menu that appears. Display or hide one or multiple sheet tabs with hide unhide feature.
Or right click the worksheet tab and choose hide option you could hide single one sheet.
On the left pane right click thisworkbook and select insert module from the context menu. Then do the same to hide every worksheet you wish. Or right click the worksheet tab and choose hide option you could hide single one sheet. Normally you can use the veryhidden function to hide the worksheets first and then set a password for them please do as following steps.
