1. Check the Real Used Range
Press Ctrl + End. If Excel jumps far below or far to the right of your real data, the workbook has a bloated used range. Delete unused rows and columns, save, close, and reopen the file.
2. Remove Excess Formatting
Formatting entire columns or rows can make a workbook much larger. Clear formatting outside the actual data range. Conditional formatting applied to whole columns is a common culprit.
3. Compress or Remove Images
Logos, screenshots, and pasted images can add several megabytes. Compress images in Excel or remove images that are not needed for the email recipient.
4. Remove Hidden Sheets
Hidden sheets may contain old exports, backups, or temporary calculations. Review hidden sheets before deleting them. If they are not needed, removing them can reduce file size and make the workbook easier to understand.
5. Use a File Size Reducer
The Reduce Excel File Size tool can rewrite and compress a workbook in your browser. It is useful when you need a fast before-and-after reduction before emailing.
6. Save as XLSX Instead of XLS
Older XLS files can be larger and less efficient. If possible, save the file as XLSX. Make sure formulas and macros still behave correctly after conversion.
Email-Friendly Checklist
- Remove unused rows and columns.
- Clear formatting outside the data area.
- Compress images.
- Delete unnecessary hidden sheets.
- Save, close, and reopen before checking final size.
- If still too large, share with a secure file link instead of email attachment.