Forum Discussion
Reduce excel size due to excess formatting
How do I reduce the size of my file due to excell formatting?
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).
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.Apply to selected "empty" range (e.g. from first row after the date till end of the sheet) Clear All
, save and reopen workbook
