How do I reduce the number of lines in a spreadsheet?

[Philamon]

Simple question - how do I reduce the number of lines in an Excel spreadsheet
from say 25000 to say 45? Delete doesn't work.

 

[Ron de Bruin]

Hi Philamon

You can't delete rows in excel but you can Hide them
Check out this first before you do that
http://www.contextures.com/xlfaqApp.html#Unused

 

[Pete_UK]

You can hide the unwanted rows: highlight the row identifier for row
46, then hold down the SHIFT key and press END followed by DOWN-ARROW,
then release SHIFT. Click on Format | Row | Hide.

Hope this helps.

Pete