Hiding almost all cells in a worksheet

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
Mike said:
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
Click to expand...

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
 
Back
Top