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

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?

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

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

JoeOvercoat wrote:

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

Del Range Close/Open How...delete..lines at bottom of...worksh
 

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.

"Dave Peterson" wrote:

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

JoeOvercoat wrote:

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