File size suddenly increased from 0.5mb to 20mb | Excel forum

Hi Doug, thanks

I had already checked the last cell using Ctrl+End and it always took me to the expected cell.

I think I have somewhat figured it out. I have ~20 columns in one tab with conditional formatting and validation, which differs for each column. Dragging the formats/validation down to the last cell (row 300 in my sheet), one column at a time, seems to have increased the file size. However, if I select the entire top row and drag down (i.e. all columns at once, instead), the file size does not increase.

My main issue is that seemingly, once a file size increases, very little can be done to reduce the size again, bar deleting absolutely everything. However, I am building up and earlier version of my document to match what my most recent version was, and am having no trouble.

Seems almost to be something of a bug in excel rather than something I did.

Thanks again for your quick response