How to change the number of rows in a worksheet.

  • Thread starter Thread starter Bloo
  • Start date Start date
B

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