Breadcrumbs

Unhide All

Overview

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/7XcWLe7kLyAnehUKX3at_GE5WIFKPe7CvA.png


The Velixo Unhide All feature shows all rows and columns that are hidden in the active worksheet.

Use with Auto-Hide

If you have used the Velixo Auto-Hide feature...


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/1h6M4-RV3M2UJEt9m-FY8Zxm6-l2Tuc65g.png


The Unhide All feature will temporarily reveal the automatically hidden rows and/or columns. When Excel recalculates the workbook, the rows/columns which match the saved criteria will again be hidden.

If you wish to permanently unhide all auto-hidden data, select Forget Auto Hide / Unhide Ranges from the Unhide All button's pulldown:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/R47dilH493nK7VIeoWp-pfHnmJeEz732ew.png