This will open the Unhide dialog box that lists all the hidden worksheets Right-click on any of the existing worksheet tab.Suppose you have an Excel workbook that has 10 worksheets that are hidden.īelow are the steps to manually unhide worksheets (one at a time): If you only have a few worksheets that are hidden, you can manually unhide some or all of these worksheets. Unhide All or Selected Sheets Using Custom View.Unhide Selected Sheets (Based on User Selection).Unhide Sheets With Specific Text in the Name.By Adding Macro to QAT (with One Click).
