Video Unhide First Column And Row In. This makes me conclude that it is the row hiding part which is time consuming and not the searching of. Select the row before the hidden row and the row after the hidden rows in the row header.
Under Visibility click Hide Unhide and then click Unhide Rows or Unhide Columns. Do one of the following. Other solutions for unhiding first row or column.
On the Home tab in the Editing group click Find Select and then click Go To.
Click Format Hide Unhide Unhide Rows or Unhide. To unhide columns again make a selection that spans the hidden columns and use Control Shift 0. Among the displayed option click on Unhide. Using your mouse select the column before and after the hidden column.