If you build a workbook that contains a lot of worksheets, you might find it easier to navigate the workbook if you can’t see the sheet tabs of the worksheets you’re not using. You can hide the sheet tabs of worksheets so they don’t appear in the Excel window, reducing the clutter and letting you find the worksheets you are using with no trouble.
Hide or Unhide a Worksheet
Hold down the Ctrl key and click the sheet tabs of the worksheets you want to hide.
Right-click any selected worksheet tab and then choose the Hide command.