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

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

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

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
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM
When I select "Open" from the "File" menu in Excel, I get only a . dan Excel Discussion (Misc queries) 1 November 30th 04 11:25 PM
How to remove an Excel Main Menu item inserted by .xla file Dennis Excel Discussion (Misc queries) 5 November 28th 04 08:39 PM
Excel How do I create a comma delineated xls file to a comma delineated. Mark Excel Discussion (Misc queries) 0 November 26th 04 10:28 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 01:51 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"