eliminate white space in Excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

Eliminating Blanks in a Summary Sheet 5
How do I eliminate duplicae records in excel file 1
Linking blank cells 1
Remove white space in print preview 2
How do I free up the space occupied by empty rows? 2
How do I eliminate a symbol? 1
how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet 10
Scripts / Macros in Word and Excel 11

Back
Top