How to change the number of rows in a worksheet.

[Bloo]

Hi,
Could someone help me, for some reason i couldn't find any info on how to
change the number of rows in a worksheet.
for ex: someone sent me a worksheet with 65526 rows in it, how can i change
that to 1000 rows only...(the datas only up to the 800th row)

Many Thanks!

 

[Gord Dibben]

You cannot get rid of the extra rows but you can select from row 1000 to end
and hide those rows under Format>Rows>Hide

Select row 1000 and SHIFT + End + Downarrow to select all rows to end.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Simon

Wouldn't CTRL + End work as well as your macro?


Gord Dibben MS Excel MVP