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


"Stephen Tyrrell" wrote:

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?