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

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i combine excel worksheets 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How to delete Blank lines in excel workbook? 2
Word How to delete line in Word 3
How do I delete extraneous EXCEL columns? 2
Excel Concatenate with line breaks but ignore blank cells 3
one cell in my worksheet appears blank, but answr shows in formula 6
print selected cells in Excel 3

Top