Forum Discussion
Stacy7438
Sep 02, 2020Copper Contributor
Reduce excel size due to excess formatting
How do I reduce the size of my file due to excell formatting?
SqueakySneakers
Sep 02, 2020Brass Contributor
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.