 Hide any confidential information in any of your Excel sheets following these two ways. Right-click on the sheet you want to hide and in the menu that opens, select the Hide option. As you can see now, the sheet is not visible. If you want to see it again, go back and right-click and select Unhide and that's it. View my caffeine addiction with a cup of Joe, please. If you have a sheet you want no one else to see, then right-click but now click on View Code. Go to the visible section. Here click on the last option in the drop-down menu and select Sheet Berry Hidden. Nobody except you can see the information. To unhide the sheet, press Alt plus F11. Now a window is opened where you can find and select your hidden sheet. Go to the visible section. Now in the drop-down menu, select the visible option and that's it.