Forum Discussion
Reduce excel size due to excess formatting
How do I reduce the size of my file due to excell formatting?
5 Replies
Hi Charla,
That was the first thing I tried with mine and it reduced the size only 2k, but it is worth trying.
- Hi Squeaky,
Yeah, as you say, it may only get minimal results in reducing size and I think your suggestion of removing empty (but formatted) rows would likely get better results.
Hi Stacy,
What worked for me is I went down to the last row of data on my sheet, that was row 6200. I clicked on the row number to highlight the whole row, then held the shift button as I scrolled to the bottom row by click-holding the slider and dragging it all the way down the the bottom (row 1 million and something), still holding the shift key, then click on the last row so all everything from 6200 to the bottom of the spreadsheet are highlighted, (you can release the shift key at this point) then delete those cells by right clicking on the row number and select delete. This took my spreadsheet from 41 meg to 7.
