Test for hidden data  
 
With this tool you will be able to detect rows, columns and hidden sheets inside of the workbook.
 
In the following example , if you have hiden rows.
 
1. Active the cheek which corresponds to the option that you want to make it viewable

In this case , we will active the corresponding cheek to rows.

 
 
2.-Click on the OK button.

As a result we will obtain a display of the hidden data.