Quickly Hide Other Workbooks (All Inactive Windows) in Excel 2007 and 2010

Normally you can hide or unhide workbook one by one in Excel, but there is no way for you to hide or unhide multiple workbooks at one time. For example, you open multiple workbooks in Excel, and you want to handle them one after one, so you may want to hide the inactive workbooks to stay working on one workbook. You cannot hide all inactive workbooks with one click in Excel, but with this Hide Inactive Windows tool of Kutools for Excel, you can:

Note: "Hide Inactive Windows" supports Undo, you can quickly unhide all workbooks by pressing Undo (or Ctrl+Z) immediately, and Undo is one level. You can also apply “Unhide All Windows” of Show / Hide to unhide all hidden workbooks.


arrow blue right bubbleClick "Kutools">>"Show / Hide">>"Hide Inactive Windows" See screenshots (Fig. 1).

hide-inactive-windows

Fig. 1 Hide Inactive Windows


arrow blue right bubbleHide / unhide workbooks in Excel

Go to View tab, in the Window group, and click Hide button will hide the active workbook; Conversely, click Unhide button to unhide workbook one by one.

Note: if the Unhide command is unavailable, there is no hidden workbooks.

unhide-workbooks

Fig. 2. Hide / unhide workbook command in Excel


arrow blue right bubble This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.

Screen shot

btn read more     btn download     btn purchase