Quickly hide all inactive worksheets in Excel 2007/2010
When you are working a workbook with too many worksheets, you may need to hide the inative worksheets. Normally, you have to select all inactive worksheets before chaning their hidden status at one time in Excel. But with this Hide Inactive Worksheets tool, you can:
- Hide all inactive worksheets of active workbook with one click. Demo
Click "Kutools">>"Show / Hide">>"Hide Inactive Worksheets". See screenshot (Fig.1).
Fig. 1 Hide Inactive Worksheets
Note: you can unhide all hidden worksheets by applying the “Unhide All worksheets” from Show / Hide group.
See Hide Inactive Worksheets feature demo (Video 1).
Video 1. Hide Inactive Worksheets feature demo.
This is only one feature of Kutools for Excel
It includes more than 100 functions and tools for Excel 2007 and 2010.
