What is the quickest way to hide a lot of rows and colums ?

S

Stephen Tyrrell

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?
 
M

Michael

Hi Stephen
You could use a Macro
Press ALT + F11
and paste this in

Sub HIDE()
Columns("A:J").Select
Selection.EntireColumn.Hidden = True
Rows("1:10").Select
Selection.EntireRow.Hidden = True
End Sub

HTH
Michael Mitchelson
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
Top