Reducing file size

Reducing file size

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.