Reduce excel size due to excess formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1629046%22%20slang%3D%22en-US%22%3EReduce%20excel%20size%20due%20to%20excess%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629046%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20reduce%20the%20size%20of%20my%20file%20due%20to%20excell%20formatting%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1629046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1629219%22%20slang%3D%22en-US%22%3ERe%3A%20Reduce%20excel%20size%20due%20to%20excess%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629219%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780018%22%20target%3D%22_blank%22%3E%40Stacy7438%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Stacy%2C%3C%2FP%3E%3CP%3EWhat%20worked%20for%20me%20is%20I%20went%20down%20to%20the%20last%20row%20of%20data%20on%20my%20sheet%2C%20that%20was%20row%206200.%20I%20clicked%20on%20the%20row%20number%20to%20highlight%20the%20whole%20row%2C%20then%20held%20the%20shift%20button%20as%20I%20scrolled%20to%20the%20bottom%20row%20by%20click-holding%20the%20slider%20and%20dragging%20it%20all%20the%20way%20down%20the%20the%20bottom%20(row%201%20million%20and%20something)%2C%20still%20holding%20the%20shift%20key%2C%20then%20click%20on%20the%20last%20row%20so%20all%20everything%20from%206200%20to%20the%20bottom%20of%20the%20spreadsheet%20are%20highlighted%2C%20(you%20can%20release%20the%20shift%20key%20at%20this%20point)%20then%20delete%20those%20cells%20by%20right%20clicking%20on%20the%20row%20number%20and%20select%20delete.%20This%20took%20my%20spreadsheet%20from%2041%20meg%20to%207.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1629259%22%20slang%3D%22en-US%22%3ERe%3A%20Reduce%20excel%20size%20due%20to%20excess%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780018%22%20target%3D%22_blank%22%3E%40Stacy7438%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20of%20extreme%20but%20the%20best%20thing%20to%20do%20would%20be%20remove%20all%20formatting%26nbsp%3B%20(Select%20entire%20sheet%2C%20then%20from%20Home%20tab%2C%20click%20on%20the%20'Clear'%20option%20and%20select%20'Clear%20Formats'%20from%20the%20dropdown).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How do I reduce the size of my file due to excell formatting?

5 Replies
Spoiler
 

@Stacy7438 

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.

@Stacy7438 

 

Kind of extreme but the best thing to do would be remove all formatting  (Select entire sheet, then from Home tab, click on the 'Clear' option and select 'Clear Formats' from the dropdown).

@Charla74 

 

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.

@Charla74 

Apply to selected "empty" range (e.g. from first row after the date till end of the sheet) Clear All

image.png

, save and reopen workbook