Hiding almost all cells in a worksheet

[Mike]

Hello,

I want to hide all rows and columns except for the few I am working
with. I am working between cells A1 to H49. Everything else I want
hidden. Is ther any other way to do this other than selecting the
unwanted rows and columns and using the Format|Rows|Hide and
Format|Columns|Hide method. That's alot of rows to hide.

Thanks for any info.

Mike

[Paul Sheppard]

Hello,

I want to hide all rows and columns except for the few I am working
with. I am working between cells A1 to H49. Everything else I want
hidden. Is ther any other way to do this other than selecting the
unwanted rows and columns and using the Format|Rows|Hide and
Format|Columns|Hide method. That's alot of rows to hide.

Thanks for any info.

Mike

Hi Mike

A quick way to select all the columns/rows is as follows >

Click on the column I header to highlight that row, use the End key followed by Right Arrow key, same for the rows but use the Down Arrow key

Then Format > Rows > Hide