Deleting unwanted and empty rows...

[Guest]

Hello,

I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the
document I have open and set up has over 65,000 rows. And...of course....the
totals for the columns appear at the very bottom (row 65,000+)

So....how do I get rid of all those rows??? I've tried to highlight and
delete but they don't go away?????

As always....thanks for your help!

 

[Bob Phillips]

Hello,

I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the
document I have open and set up has over 65,000 rows. And...of course....the
totals for the columns appear at the very bottom (row 65,000+)

Why do they?

So....how do I get rid of all those rows??? I've tried to highlight and
delete but they don't go away?????

A spreadsheet has 65000+ rows. You can't delete the excess, there will
always be 65000+

 

[Henry]

Jim,

Put your totals in row 70 and ignore all that is below that row.

Henry