If you assign a shortcut key to the following macro:

Sub HideThem()
Range(Cells(1, "F"), Cells(1, Columns.Count)).EntireColumn.Hidden = True
Range("A63:A" & Rows.Count).EntireRow.Hidden = True
End Sub

You can hide all with a single click.
--
Gary''s Student - gsnu200904


"Misho" wrote:

I have a worksheet that have text from A to E & form 1 to 62.

I usually select all the rows after my data then right click then Hide and
the same I do for col.

Is there a way that I can do it faster?