Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim
 
Posts: n/a
Default 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   Report Post  
Bob Phillips
 
Posts: n/a
Default



"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   Report Post  
Henry
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"