How do I free up the space occupied by empty rows?
 

I copied a large worksheet to numerous tabs in the same workbook. Then I
deleted most of the rows from each tab, but Excel still seems to think that
there is data in all of the blank rows. Consequently, the spreadsheet
occupies more bytes than it needs to and Lotus Notes won't let me email it to
coworkers because of its size. Any ideas on how to free up the unused space?
Dave

How do I free up the space occupied by empty rows?
 

Check out http://www.mvps.org/dmcritchie/excel/lastcell.htm or
http://www.beyondtechnology.com/tips019.shtml


--JP

On Sep 25, 10:59*am, davedadu
wrote:
I copied a large worksheet to numerous tabs in the same workbook. *Then I
deleted most of the rows from each tab, but Excel still seems to think that
there is data in all of the blank rows. Consequently, the spreadsheet
occupies more bytes than it needs to and Lotus Notes won't let me email it to
coworkers because of its size. *Any ideas on how to free up the unused space?
Dave

How do I free up the space occupied by empty rows?
 

JP - thanks - I tried the second link that you provided and that did the trick!
"JP" wrote:

Check out http://www.mvps.org/dmcritchie/excel/lastcell.htm or
http://www.beyondtechnology.com/tips019.shtml


--JP

On Sep 25, 10:59 am, davedadu
wrote:
I copied a large worksheet to numerous tabs in the same workbook. Then I
deleted most of the rows from each tab, but Excel still seems to think that
there is data in all of the blank rows. Consequently, the spreadsheet
occupies more bytes than it needs to and Lotus Notes won't let me email it to
coworkers because of its size. Any ideas on how to free up the unused space?
Dave