Cut file size

A golden rule is to avoid having pictures in Excel. If you have to use pictures anyway, a good practice is to always compress them:. Formatting enables the eye to naturally structure information. However, formatting your data will also weigh your sheets down. Trust me, we love formatting data too! People who work on large files with many sheets and formulas know what watches are not the one on your wrist!

When numerous, they will weigh down your spreadsheets. Make a copy beforehand. Now that you can see your entire Excel file, you can delete all unnecessary sheets , columns and rows. Moreover, you can easily audit your file to spot heavy sheets with the method we used at the beginning of the article. At UpSlide, we like to work on light files. That is why we created a feature that does the work for you: the Smart Clean!

It applies all the above tips in the blink of an eye. The delete empty rows trick… OMG, that is a game changer for me. That was why my files were in the tens of megs. Thank you. Dear Will, Thanks for spotting this! We added two extra steps so you can see how to effectively change your file extension to ZIP. You can use Ctrl-End to find the outmost cell that is being saved. Hi Bart, Thanks for the tip! I deleted all 3 and the used range is now down to about 50 columns, then saved the file.

This resulted in no reduction zero k in file size. I verified that the used range is now correct and this bloated columns are gone, so why no change in size? Fantastic Post, thank you very much. The ZIP file method is incredible, I will not forget that going forward. We went from 46MB to KB. I tried 1st method but xecel file size increased 12MB to MB and system fully slow.

But then I follow all series wise finally reduce excel file size. Direct access to content Direct access to menu Back.

Do you want to know how to reduce your Excel file size? Table of Contents Hide. First, audit your large Excel file.

Tip 1: Remove conditional formatting. Tip 2: Crop each worksheet to its used range. Tip 3: Remove unnecessary formulas. Tip 4: Compress pictures in Excel. Tip 5: Clear data formatting. Tip 6: Delete watches. Tip 7: Eliminate hidden data sheets, rows and columns.

Safe and Secure Your files are encrypted in transit and are stored only briefly on our secure Microsoft Azure app servers before being deleted.

How to compress files online Drag or click the add file button to choose your document or image. Click to download the smaller file to your local computer. Have you selected the correct file? This file may have been compressed by WeCompress. Re-compressing the same file won't work… Select another file. Avoid long uploads! Mac OS. Like WeCompress?

Try our Desktop software NXPowerLite Desktop is fast, convenient, has no size limits and can compress multiple files at once. Your download has started! Contact us We'd love to hear from you! Full Name. Email 2. Send message. Thank you for contacting us. We have received your inquiry and we will respond to you soon.

If you don't hear from us then please double check the email address you entered on the form.