keroppapa.blogg.se

Unfortunately, there is no in-built functionality in Excel to quickly unhide all the hidden worksheets (or a way to select more than one worksheet and unhide it). If you want to hide worksheets, you can select multiple worksheets at once (hold the control key and click on the worksheet tab name), right-click and click on the Hide option. You can hide worksheets in bulk, but not unhide in bulk

As of now, you need to use the unhide dialog box where you can only select one worksheet to unhide. Note: Unfortunately, there is no in-built functionality in Excel to quickly unhide all the hidden worksheets (or a way to select more than one worksheet and unhide it). The above steps would unhide the select worksheet. In the Unhide dialog box, click on the worksheet that you to unhide (you can only select one at a time).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).