20 July 2013
Are your spreadsheets always as small as they could be? This article considers common methods of reducing file size:
- Locate CTRL + END cell on each worksheet.
- Clear blank cells.
- Reducing size using *.xlsb as an intermediary.
- Reducing size for workbooks specifically containing charts and / or formatting.
- Reducing size for workbooks specifically containing text only.
- Zipping the file as an intermediate step.