eliminate white space in Excel file
I have a large Excel workbook that contains several sheet tabs. It must be
e-mailed monthly. Is there away to eliminate the unused cells from the file to condense it. |
no. what is there is there and cannot be added to or
reduced. http://www.rondebruin.nl/sendmail.htm See this site for suggestions/alternate ideas. -----Original Message----- I have a large Excel workbook that contains several sheet tabs. It must be e-mailed monthly. Is there away to eliminate the unused cells from the file to condense it. . |
A workbook must have a minimum of ONE worksheet. So, you may eliminate the
others. You may not delete unused rows/columns. But, use ctrl+end to find the last used. Delete (not clear) unused and SAVE. You may hide all unused rows/columns -- Don Guillett SalesAid Software "WhirlWind" wrote in message ... I have a large Excel workbook that contains several sheet tabs. It must be e-mailed monthly. Is there away to eliminate the unused cells from the file to condense it. |
No. Each worksheet has exactly 16,777,216 cells, and empty cells don't
add to file size. An empty worksheet (tab) will add a small amount, but hardly worth the effort of deleting it. In article , WhirlWind wrote: I have a large Excel workbook that contains several sheet tabs. It must be e-mailed monthly. Is there away to eliminate the unused cells from the file to condense it. |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com