Excel: Reduce the file size of your Excel workbook | Excel tips and tricks

Have you ever had a large Excel file that you know should be significantly smaller? There are a couple of tricks to reducing the file size. One tip is to delete all blank rows and columns in the file. Another tip is to delete any worksheets you do not need. I show how to use Workbook stats to see file information.

Chapters:
0:00 Intro
0:21 Initial file size
0:50 Workbook stats
1:30 CTRL + Home
1:42 CTRL + END
2:35 CTRL + SHIFT + Right arrow
3:05 CTRL + SHIFT + Down arrow
4:05 Signs your file is too large

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[TheParaRog]

Old video but just saved me a whole world of pain, thanks so much for this.

[veronicabassen]

Wow, I was shocked at having to send such a large file to a customer. I'm so glad I found your video!!!

[justclipstools]

Years of my life have been wasted not knowing this!!! Thank you so much!!!

[kathymcnair]

Hiya Chris! Thank you much for this video! I was in a bit of a panic because my spreadsheet increased to 43MB. I knew the max size is 50MB - this is a spreadsheet that I maintain all year, and we were only 5 months into the year. I was close to maxing the file out! Thanks to your tips, the size went from 43MB to 18MB. One of the worksheets had the end of data row at 1 million+!! I deleted those rows, and BAM! :) I owe you a beer! 🍺

[hope]

Thank you so much, it worked. I just love the way you started asking "hope you have a wonderful

[timpriestley]

Your a Legend Sir !!!! Thanks God Bless! Not all hero’s wear capes !!! Thanks a million…… you were a lifesaver at Work! When IT couldn’t help u did!

[Monica]

Thank you so much I have seen other videos that they drag it out and it seems they are more interested in showing you how much they know, , , about the tools... worked like a charm.

[HammerKrazy]

Thank you so much for these great tips! I create/modify extremely large reports for work in excel, and you have saved me an incredible amount of time! You are a

[terminator]

Thank you Chris, you just solved my biggest headache and are a lifesaver. I couldn't figure out how to fix it until I watched this video, my file size was 32.0m and it was a few kinds of stuff that I formatted, I was shocked when I saw my file size was that heavy. After following your instructions (simple and quick fix), my file size now is 64.6KB and that's the size should be. Thanks for sharing and the time to upload this video.

[shoaibrehman]

Huge thanks just removed lines from multiple sheets, size shrink from 91 mb to 11mb. Work in my case.
Thanks

[amalantony]

Thank you ❤ This tip massively reduced my spreadsheet size . I initially thought the pivot tables might be causing this issue, it was actually the hidden data in the empty cells

[DanielSmjuntak]

Looking for this since forever. Finally find solution that works actually

[jims]

Brilliant fix. Worked perfectly and saved my day. Thanks!

[Sue_Miposi]

Thank you!!!! So much!!! Sooo much!! You just saved me from a whole lot of stress

[scottlippa]

Chris. I love you. You are a lifesaver. Thank you so much!

[punithvyas]

Thank you very much for detailed explanation. You have really made it simple. I have seen other vedios but not got proper solution. I have implemented the idea, you have explained in this vedeo, and experienced miracle.I am sure this will help many users to save time and space.

[anthu]

Very informative Chris, thanks a lot!

[rickyc]

Thank you so much! This will save me so much time now!!!

[ivanteo]

Thanks, you saved me 195mb. So why does excel assume there are data in the blanks?

[MrYoyomor]

Thank you so much for a simple, easy to understand explanation.