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

[@justclipstools9590]

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

[@veronicabassen4878]

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

[@Monica31667]

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.

[@ChrisMenardTraining]

Thank you, Monica.

[@timpriestley3391]

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!

[@ChrisMenardTraining]

Not sure about that, but I appreciate the positive comment! Thank you!

[@terminator3697]

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.

[@TheParaRog]

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

[@ChrisMenardTraining]

You're welcome!

[@hope1913]

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

[@ChrisMenardTraining]

You're welcome! Thank you, Hope.

[@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 lifesaver!!!!!

[@kathymcnair8129]

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! 🍺

[@amalantony8594]

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

[@ChrisMenardTraining]

Thanks, Daniel. I'm glad it worked.

[@scottlippa1224]

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

[@jims3721]

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

[@ChrisMenardTraining]

You're welcome!

[@Sue_Miposi]

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

[@olqkicek]

Thank you for this tutorial. It really helps me in my daily work.

[@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.

[@ChrisMenardTraining]

Thank you, Punit.

[@MrYoyomor]

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

[@anthu22]

Very informative Chris, thanks a lot!

[@ChrisMenardTraining]

My pleasure!

[@rickyc3860]

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

[@ChrisMenardTraining]

You're welcome!

[@windiesmith7825]

Excellent tip!

[@ChrisMenardTraining]

Thanks for watching! I appreciate the feedback.

[@inasabubaker1617]

thank you :) u made my day, ive been struggling to know why my sheet getting that big size :D

[@benayoraklibel3526]

Chris, you are wonderful thank you so much!!

[@HaroldAstor62]

Wow Chris, thank you so much for helping me to solve my problem. Coincidently my big files have 20 MG so I felt you were talking to me. Hehe. God bless you, my friend. My name is Harold Astor from Puerto Rico. Thank you 😊

[@HaroldAstor62]

I did what you say in the video but the file didn't get compressed

[@shoaibrehman9988]

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

[@ChrisMenardTraining]

Great 👍

[@Monica-70]

You are AWESOME! Thank you for this!!!

[@ChrisMenardTraining]

Happy to help! Thanks, Monica.

[@ivanteo1973]

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

[@tomuchuser]

thanks it works

[@ChrisMenardTraining]

Welcome 👍

[@praveenkumarthulasiraj5924]

Incredible ❤my work becomes easier

[@ChrisMenardTraining]

Thank you so much 😀

[@genciduraku4340]

Hahaha...That was funny, waiting to select all the rows... that made me subscribe and give a thumbs up 👍

[@ChrisMenardTraining]

Thank you. I appreciate the sub.

[@frankgrognet1616]

Great tips

[@ChrisMenardTraining]

Thank you.

[@astleywithaitch]

thanks for this! ❤

[@ChrisMenardTraining]

You're so welcome!

[@SariahMansoer]

Thank you Sir! You are a life saver. Apparently deleting rows doesn't always result in deleting rows. Saved me 45 MB out of 50 MB.

[@ChrisMenardTraining]

That is a significant difference. Thanks, Sariah.

[@abdurrahmannayeem297]

Thanks man . Thank you so much

[@Yojikman]

I did exactly same, thanks to this video but file size reduced just little bit... want shall I do?

[@InsightsintoAi]

Spot on thanks

[@ChrisMenardTraining]

You're very welcome

[@ahmadjamil1853]

Thank you Sir😌

[@ChrisMenardTraining]

Welcome 😊

[@MichaelMokaya-d4k]

It saved me big time

[@ChrisMenardTraining]

Thank you!

[@yoyoyonasa]

Thx very much useful 👍

[@ChrisMenardTraining]

You're welcome 😊

[@ducquangnguyen4143]

This man saved my life! Need to log in to say thank you.

[@ChrisMenardTraining]

Thank you! I appreciate the awesome feedback.

[@selahstambaugh1989]

Thank you!!!

[@ChrisMenardTraining]

You're welcome!

[@klopptillyoudropp1263]

THANK YOU!!!!!!!!!!!!!!

[@ChrisMenardTraining]

welcome.

[@ndk-arts-n-excel]

Thanks for this beautiful tip. I used to filter the same but with little difference, when I am beyond Cell A8983 (from your example), like it is AA11000, I will select all the cells from A8984 to AA11000 and count them as they make 2017R x 27C and I go to GO-SPECIAL and choose Blanks. Now they make 2017x27=54,459. When I write something like "-" and press Ctrl Enter, this gives me the same figure 54,459, so it is OK to delete as you proceeded to, else, if the figure is less than 54,459 then I undo and check why I am going to AA11000 on pressing Ctrl End? Then repeat the same process by selecting all the cells from M1 (from your example) to AA11000. Thanks

[@harrymiles7295]

very helpful, thank you

[@rashiagarwal3152]

super handy trick

[@ChrisMenardTraining]

Thanks, Rashi.

[@AlbertoJacinto-lt8ow]

this video saved me

[@gowthamvignesh17]

Superb Its working ☺☺

[@dw2898]

I have a spreadsheet with several tabs, cells with data, NO formulas, and not much formatting other than sorting. The file was over 24,000 KB. Thanks to deleting these excess empty rows, it is now down to 151 KB. Thank you!

[@janelisan8560]

Thanks a lot 😊

[@davelernstift]

This works. Much obliged.

[@rekhachez8211]

Thankyou it worked

[@swarooppatil1092]

Thanks for sharing 👍🏻

[@ChrisMenardTraining]

My pleasure 😊

[@septianaryapratama7973]

thank you , really great explanation.

[@daviddeherrera3015]

How long would it take for the rows and columns to delete and would this work for Mac?

[@ChrisMenardTraining]

The rows and columns on my Dell delete in 1 to 4 seconds at the most. I have an i7 processor, 6th generation with 32GB of RAM. The computer is 4 years old. I don't have a Mac, but it should work on a Mac. It is the Excel file that is causing the issue, not the OS. I hope this helps. Thanks, David.

[@kitty2katty]

Thank you so much - what a life saver!

[@somnorila9913]

It's pretty self explanatory. Just like you said, takes time even with a pretty fast computer. Had this issue on a computer not too long ago and this way was not a solution because i got error pretty much because to do all that it would need more resources. And the computer used is not that bad cpu wise but pretty low ram wise. So my fastest solution was to just copy the data in a new sheet and delete the old one. I'm more interested if there is a way to lock the size of newly created excel files as a policy to basically not allow sheets to contain more rows than a set value. From what i seen until now it's not really an option in the way i want it to be, which kind of sucks.

[@latifahmbugua1016]

And how do I regain back the size? Like the columns and rows

[@HowToAnalyst]

Chris - great video, thank you for sharing! Do these techniques work on Excel files in the cloud / on your browser? Or just for files on your desktop?

[@fairygeekmother]

I was thinking the same thing. I have a Microsoft form that collects info into a shared online workbook. Is this safe without breaking the connection to the form?

[@amandadias4599]

Thank u!

[@ChrisMenardTraining]

You're welcome!

[@renisilaen5371]

Thank you so much .....

[@ChrisMenardTraining]

You're welcome.

[@Said.Z2]

Thank you So much!! Hope you can do the same with word

[@fredericknakeisha809]

Thank you so much! I had the same issue

[@ChrisMenardTraining]

You're welcome!!

[@mahmoudelzar213]

thanks ❤

[@ChrisMenardTraining]

You're welcome 😊

[@lanphiliparenque1843]

Thank you

[@ChrisMenardTraining]

Welcome!

[@ritauy5500]

How do i reduce the size of an excel screen shot to only occupy 50% of my laptop screen, the reason is i need to have other system report occupy the 50% of my laptop, i need to look and work on both reports. I am paralyzed only have LEFT hand and no mouse to work on. Thanks for any advice you can advise

[@JonathanExcels]

When you have this situation You will also notice that the vertical scroll bar is much smaller than it should be. And as long as you are using keyboard shortcuts to select you could use them to delete. Ctrl- deletes selected rows or columns.

[@ChrisMenardTraining]

Good tip Jonathan. Thank you!

[@misst1078]

THANK YOU SO MUCH I know I am typing in all caps. I just worked on a spreadsheet and my email said it was too large.

[@ChrisMenardTraining]

Glad it helped!

[@vickysykes8725]

How to decrease, if pdf attachment in excel, sir?

[@PaulSoteroAshton]

Hi Chris, great video. For some reason this is not working on my spreadsheets. It used to, but now I get no change =( and after hitting Ctrl + End still get back to same cell and column AI 48461 (when my data is only up to AI 78). Any idea on what to do?

[@aminediab3134]

Hello, I am trying to hide all unnecessary files and my files get to 7mbs. Is there any way to reduce it to KBS size while still being able to hide a million rows and the rest of the columns? Much appreciated

[@trilokavi1982]

What's the way to reduce unnecessary Rows and Columns for EXCEL IN ONEDRIVE

[@Imaneaddams]

I have more than 10k unnecessary column & had tried to delete but there’s no changes 😩. I’m so stressed

[@valerdonca5694]

Delete or hide?

[@ChrisMenardTraining]

delete would reduce the file size. Hide would not reduce it.

[@chinmaybadola6736]

Hi still I'm not able to reduce size. Even when I deleted all data but still it show 11mb.

[@ashokdobhal3194]

Nice vedio

[@ChrisMenardTraining]

Thank you!

[@nancysweeney3629]

I looked online multiple times with no solution. You helped me take care of my issue in 10 min. Thanks!

[@tslane656]

I am struggling, the file size is not changing.

[@caseyhenson3601]

This does not work for me, I dont know why the file size still the same. Help

[@somnorila9913]

You probably didn't delete the rows and just deleted the content from the cells. Just watch if the size of the scroll bar changes, if you do it right that should get bigger.

[@matthewontherocks]

I've a spreadsheet with 220mb on it spanning 3 years of data, I'll comment back with how this impacts the file size

[@GloreeaR]

mine didn't work... ugh

[@KentC0813]

if this method doesn't work, you just create a new sheet and move the date to the new sheet. and that will do the job as well.

[@abellmamigo5546]

it did not work for me

[@nabilmaataoui8925]

TVERY THAKS I WAS A FILE WITH MORE THAN 100 MB I REDUCED TO 90 kb

[@ChrisMenardTraining]

That is awesome. I'm glad it worked.

[@ricoash6625]

From googlesheets to excel this is a headache

[@garrydenewaldie7257]

This free tool on the Microsoft Store is well worth looking at. Especially when you have an excel file that you have been adding to over the years. It is holding all kinds of old styles inside that file that is using up space. I have used this tool safely on massive Excel files that kept crashing. Get XLStylesTool - Microsoft Store

[@abinsmm5834]

It didnt work for me