Home MS Excel TutorialExcelTips and Tricks How to Reduce Excel File Size

How to Reduce Excel File Size

by Easy Excel Tutorials

How to Reduce Excel File Size

There are different ways to reduce the file size of Excel, you could zip the file, save as xml, or compress the file.

But first, look at this file’s size:

file size

Note: You could just right click on the file, and choose zip or compress in the options showing. However, you would need a program like WinRAR, WinZip, or any other program that zip. If that suits you perfectly, please do.




Open the file, click on the things that make the file large (in this case the picture).

picture

With the picture marked, click on format (1), and then compress picture (2).

compress pictures




Press ok

press ok

Note: Repeat these steps on all the pictures, or other.

Use “Save As” to save the file in .xlsb format




xlsb format

In conclusion, the size reduction might not be much, but it is something.

Template

You can download the Template here – Download



Further reading: 
Basic concepts 
Getting started with Excel
Cell References

You may also like