Deleting unwanted and empty rows...
 

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!
--
CWJ

"Jim" wrote in message
...
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+

Jim,

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

Henry


"Jim" wrote in message
...
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!
--
CWJ