Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"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+ |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|