You might wish to add new worksheets as you add more data to your Microsoft Excel spreadsheet.
Some spreadsheets may eventually include outdated data and no longer require frequent examination.
You may hide the spreadsheets you aren’t using to make it simpler to locate and display the ones that are most relevant to you.
When you wish to use them again in the future, you may afterward unhide them as necessary.
Use these instructions to hide or reveal a worksheet in Excel.
Hide a worksheet
- To reveal the worksheet, open the Excel file that contains it.
- Right-click the worksheet tab in the Excel window’s bottom.
- Choose Hide from the menu.
To conceal a worksheet with the name Sheet2 for instance, right-click the Sheet2 worksheet tab and choose Hide.
Unhide a worksheet
- To reveal the worksheet, open the Excel file where it is stored.
- Right-click any worksheet tab located in the Excel window’s bottom.
- Choose Unhide from the menu.
- Select the worksheet to be unhidden in the Unhide window, then click Ok.
To unhide a worksheet with the name Sheet2 for instance, right-click any worksheet tabs and choose Unhide.
Select the Sheet2 worksheet in the Unhide box and press Ok.