How to find what is making file size so large?

[c.clavin]

Hi guys, my workbook jumped from 1mb to 6mb after a day of work to it. I didn’t look along the way what was making it jump. Is there a quick way to see what is making the file size what it is? Thanks!

 

[jolivanes]

Count shapes in the various Sheets.
Check if you formatted whole columns instead of ranges needed.
See what the last cell in each sheet turns out to be

 

[Alex Blakenburg]

Since you are using MS365, if you are storing the workbook on OneDrive or are happy to load the workbook to OneDrive, you could try this:

Cleanup cells in your workbook - Microsoft Support

support.microsoft.com

If you elect to optimise, it will reset the UsedRange on all worksheets.
It's only available in the Online version of Excel

 

[c.clavin]

Will give this a look, thanks for the replies!