Hi Bob,

If you use the mouse to select the top row, 10 in the OP's case, and the
whilst holding left button move up to the actual column headers you can
then via the menus use Format Row Unhide.
This way if any other rows are hidden they will remain hidden.

Cheers
Andy

Bob Phillips wrote:
Select the whole worksheet, Ctrl-A, FormatRowUnhide.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info