Quickly unhide all rows and columns in Excel 2007/2010

It's quite easy for you to hide one or more rows or columns in Excel. You can quickly hide rows or columns that contain the certain information for preventing others seeing the content, or any other purpose. Since hiding rows or columns is such handy feature, you may frequently use this feature in Excel. But Excel does not support you to unhide all hidden rows and columns with one click. Kutools for Excel augments Excel with this Unhide All Ranges tool to:

• Quickly unhide all hidden rows and columns of active worksheet with one click. Demo

Note: “Unhide All Ranges” supports Undo. You can press Undo (or Ctrl+Z) immediately to restore the operation, and the undo is one level.

Click "Kutools">>Show / Hide">>"Unhide All Ranges". See screenshot (Fig.1).

Fig. 1 Unhide All Ranges

See Unhide All Ranges feature demo (video 1).

This is only one feature of Kutools for Excel

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