Hiding or Showing a Worksheet

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

  1. Hold down the Ctrl key and click the sheet tabs of the worksheets you want to hide.

  2. Right-click any selected worksheet tab and then choose the ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.