Why do my Excel files become huge?

Twice in the past few days, I've been working on "normal" size Excel files, and then realized that everything was becoming very sluggish.

I saved the files, which took a very long time. One file had become 35 MB, and the other one had become 4+ MB. I found one of my tabs where a control-End took me way down deep in the sheet - not to the far lower right, but to cell AI 1048554.

What am I doing wrong? Why would this happen to me twice within a few days?

What's the best way to fix it?

Thansk.
Answer
Answer

Hi,

 

Try this

 

1. Identify the last filled up row of data and click on any cell in one row below that

2. Select from that row till the end and delete all rows

3. Do the same for columns

4. Save and close the file

5. Shut down MS Excel

6. Reopen the file

 

Does this solve the problem?

Regards,

Ashish Mathur
www.ashishmathur.com
http://twitter.com/excelashish

1397 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated January 26, 2021 Views 344,859 Applies to: