How do i delete blank lines at bottom of an Excel worksheet?

[JoeOvercoat]

How do I delete the blank lines at the bottom of an Excel worksheet, so that
that the drag bar on the right is proportional to the populated portion of
the worksheet?

 

[Dave Peterson]

See Debra Dalgleish's site:
http://www.contextures.com/xlfaqApp.html#Unused

 

[JoeOvercoat]

Thank you - the key seems to be closing & opening my Excel 2003 file to see
the results of the row deletion, and deleting the rows by deleting a range to
bring up the "delete row" dialog box, vice deleting rows via highlighting
rows using the left navigation bar.