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

D

davedadu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I save a 40meg 26,000 row file to Space Delimited format 1
How do I, not print hidden rows (Excel) 2
How do I insert a row or rows between each row of text and copy the row above? 0
how to remove empty rows? 2
How can I enlarge the spacing between rows in a spreadsheet? 2
How do I remove empty Rows 2
Excel 2003 - deleting trailing empty rows 5
How do I display a list of the rows or columns that I've hidden? 1

Top