Skip to content

Hide and Unhide Worksheets in Excel

In this article, I will show you how to hide and unhide worksheets in Excel.

How to Hide Worksheets

To hide worksheets in Excel, select the worksheet tabs you want to hide. You can select multiple sheets by holding the CTRL key.

Next, right-click and select Hide.

Keep in mind that there must always be at least one visible worksheet. Excel will not allow you to hide all worksheets at the same time.

How to Unhide Worksheets

To unhide worksheets in Excel, right-click on any visible sheet tab and select Unhide.

Select the worksheets you want to unhide within the Unhide dialog box. Hold the CTRL key to select multiple sheets.

Finally, click OK.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top