Most folks don't know about this intersection
As Sawedoff suggests, click the intersection box of the row headers and column headers to select all rows and columns. With everything selected, not only can you hide or unhide everything at will, you can double-click the border edge of any row/column to resize all rows/columns to automatically fit the largest entry in that row/column. To autosize a single row/column double-click the bottom/right edge of the box containing the header number/letter.
Keep Up with TechRepublic