View Single Post
  #3   Report Post  
Ken Wright
 
Posts: n/a
Default

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?