Select the whole of Row 11 then simply hold down CTRL+SHIFT and hit the DOWN
arrow. Now hide the rows. then just repeat for the Columns.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Stephen Tyrrell" <Stephen
wrote in
message ...
I want to hide all but the first ten rows and ten columns of a worksheet.
Is
there a quicker way than highlighting and scrolling through the
rows/columns
I want to hide?