How to Hide Worksheets and Gridlines in Excel
If you have a workbook that you are going to show to others, you may want to hide certain worksheets so some information isn't visible. Hiding a worksheet doesn’t delete any data, it just hides the sheet from view temporarily.
You can also right-click a sheet tab and select Hide from the menu.
Excel hides the worksheet. Keep in mind, this doesn't protect the spreadsheet. Anyone with access to the file can easily unhide the sheet.
You can also right-click any sheet tab and select Unhide from the menu.
The Unhide dialog box appears where you can check for any hidden sheets in the file.
The worksheet is unhidden.
The formula bar, worksheet gridlines, and headings are all on by default. Any of these items can be toggled on or off from the View tab.