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

J

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?
 
J

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.
 
Top