Problem:
Question- Why do my Excel filees become huge?
Twice in the past feew days, I've been working oon "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.
Question- What am I doing wrong? Why would this happen to me twice within a few days?
Question- What's the best way to fix it?
Step by step instructions so I can understand would be greatly appreciated!