Often Excel files get too much heavy and it becomes very annoying to work on it. Here I shall share tips to reduce size of Excel files.

1. Remove unnecessary Conditional Formatting

2. Remove unnecessary formulas.

3. Clear unnecessary data and formats beyond used range in worksheet.

4. Delete watches.

5. Eliminate unnecessary hidden columns, rows, sheets.

6. Compress pictures in excel.

7. Remove hidden objects

8. Delete unused names containing broken links.

9. Remove Pivot cache.

10. Save in Binary format (.xlsb).

11. Compress file.

If you want to know more about it in detail then you must read this article.

Click Here to Read the Article