Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. . |
#3
![]() |
|||
|
|||
![]()
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. |
#4
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
When I select "Open" from the "File" menu in Excel, I get only a . | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) | |||
Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |