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

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Philamon" <[email protected]> wrote in message news:[email protected]...
> Simple question - how do I reduce the number of lines in an Excel spreadsheet
> from say 25000 to say 45? Delete doesn't work.

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