Sometimes u face this problem. u come around an MS Excel file and find some rows are hidden..
If u unhide one by one then it will be time consuming process..
and if u want to find any data in the sheet with hidden rows then if that data available in hidden row then find tool won’t go through that hidden rows…
So u have to first unhide all rows.. that time this solution is useful..