How can I minimize the file size of an Excel spreadsheet?

E

Eileen Adams

I have a multi-page Excel spreadsheet. Each page only uses an 8.5 x 11 inch
area, yet the file is 22 megabytes. It takes a long time to open and save.
 
D

Dave Peterson

If you hit ctrl-end (on each worksheet), do you go way past where you know the
data ends?

If yes...

Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

And if you have pictures/objects/comments embedded on those worksheets, they
could be causing trouble.
 

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

Embed the same Excel multiple times 0
How can the font and size of (all) citation numbers be altered? 1
How to print OneNote 2016 for Mac pages to fit on 8.5 x 11 inch paper 0
Slow opening spreadsheet with images in Excel 2007 0
Merging from an Excel file with graphics 1
How do I set up a page sized 17 x 11 inches? 1
How can I print rows that go outside of the page without shrinking the text? 0
Mac Word - template 1

Top