Why Excel files grow large and what to do about it
Excel files balloon when they contain unused formatting, hidden rows and columns, embedded images, or calculation history that Excel keeps in the background. A spreadsheet that looks small on screen can be several megabytes because of invisible data you never see. The fastest way to shrink it is to delete the data you no longer need, then remove the formatting Excel applied to empty cells.
Before you start, save a copy of your file with a different name. That way if something goes wrong, you still have the original. Then work through the steps below in order — each one removes a different type of bloat, and doing them in sequence catches the most common culprits.
Key Takeaways
- Delete entire unused columns and rows rather than just clearing their contents, because Excel keeps formatting on empty cells and that adds file size.
- Remove embedded images and replace them with links if you need to keep them, since images are the single largest source of bloat in most spreadsheets.
- Clear the undo history by saving the file, closing it, and reopening it, which forces Excel to discard the list of changes it normally keeps in memory.
- Use the built-in "Remove All" button under Paste Special to strip formatting from cells you want to keep, which often cuts file size by 20 to 30 percent.
- Save as .xlsx (Excel 2007 format) rather than .xls if you are using an older version, because the newer format compresses better.
Delete unused columns and rows completely
Clearing the contents of a column is not the same as deleting it. When you press Delete on a cell, Excel keeps the formatting — the font, the background color, the cell width — and that formatting still takes up space in the file. You have to delete the entire column or row to remove it from the file.
Right-click on the column header (the letter at the top) or row header (the number on the left) and select Delete. Do this for every column and row you no longer use. If you have hundreds of empty columns to the right of your data, select them all at once: click the first empty column header, then hold Shift and click the last one, then right-click and delete.
After you delete columns and rows, save the file. This forces Excel to rewrite the file structure without the deleted data.
Remove or replace embedded images
A single photograph or chart image embedded in a spreadsheet can add 500 kilobytes to several megabytes to your file size. If your spreadsheet contains images you inserted by copying and pasting or by using Insert > Pictures, those are the first thing to remove.
Click on each image and press Delete. If you need to keep the image but do not need it in the spreadsheet itself, save it separately to your computer first (right-click the image, select Save as Picture), then delete it from the sheet. If the image is a chart that shows data from your spreadsheet, convert it to a link instead: delete the embedded version, then create a new chart in a separate file and link to it from your spreadsheet using a hyperlink.
Strip formatting from cells you want to keep
Excel applies formatting to cells even when they are empty. If you have formatted a large range of cells with colors, fonts, borders, or number formats and then deleted the data, the formatting remains and adds to file size. You can remove it without touching your actual data.
Select all cells in the sheet by clicking the box in the top-left corner (where the row numbers and column letters meet). Go to the Home tab, click the arrow next to Paste Special, and select Paste Special. In the window that opens, click Clear All at the bottom. This removes all formatting from every cell. Then undo this action (Ctrl+Z) and redo it only on the cells you actually want to clear: select just the empty areas, then repeat the Paste Special > Clear All step.
A faster approach: select the columns or rows that contain data you want to keep, then go to Home > Clear > Clear Formats. This removes formatting only from the selected area and leaves your data untouched.
Clear the undo history
Excel stores every change you make in an undo list so you can reverse your edits. This list can grow quite large in files you have worked on for months. Clearing it removes data Excel no longer needs to keep.
Save your file (Ctrl+S), close it completely, and reopen it. Excel discards the undo history when you close the file, so the next time you open it, the file will be smaller. This is one of the easiest ways to reduce file size with almost no effort on your part.
Compress the file using built-in tools
If your spreadsheet contains images you want to keep, you can compress them without deleting them. Select an image, go to the Picture Format tab (this appears only when an image is selected), and click Compress Pictures. Choose a resolution — Screen (96 ppi) is fine for most uses and produces the smallest file size. Click OK.
Do this for every image in the spreadsheet. If you have many images, this step alone can cut your file size in half. You can also right-click an image and select Compress Picture from the context menu if the Picture Format tab does not appear.
Save in the right format
The file format you choose affects how much space Excel uses. The .xlsx format (Excel 2007 and later) compresses better than the older .xls format. If you are saving an old .xls file, convert it to .xlsx.
Go to File > Save As, choose the location where you want to save, type a new filename, and in the dropdown that says "Save as type", select Excel Workbook (.xlsx). Click Save. The new file will be noticeably smaller than the original if it was in .xls format.
Do not save as .csv (comma-separated values) unless you only need the data and do not care about formatting, because .csv files cannot store formulas, colors, or multiple sheets.
Check file size before and after
To see how much space you have freed up, right-click the file in File Explorer (Windows) or Finder (Mac), select Properties (Windows) or Get Info (Mac), and look at the file size. Do this before you start and again after you finish each major step so you know which actions made the biggest difference.
If the file is still large after you have deleted unused data and images, the problem may be that your spreadsheet contains many sheets with data you do not use. Delete entire sheets you no longer need by right-clicking the sheet tab at the bottom and selecting Delete Sheet.
Frequently Asked Questions
Will reducing file size change my data or formulas?
No, as long as you only delete unused columns, rows, and images. Clearing formatting and compressing images also leaves your data and formulas untouched. Always save a backup copy before you start, just in case.
What if I have a very large spreadsheet with thousands of rows of data?
Delete rows you no longer need, then check whether you can split the data into separate files — one for current data and one for archive data. A file with 10,000 rows of active data will always be larger than one with 1,000 rows, but you can keep both files and work with them separately.
Can I reduce file size without deleting anything?
Partially. Clearing formatting, compressing images, and clearing undo history all reduce size without deleting data. However, if your file is large because it contains a lot of actual data (numbers, text, formulas), the only way to make it significantly smaller is to delete some of that data or move it to a separate file.
Why is my file still large after I deleted columns?
You may have deleted the contents but not the columns themselves. Right-click the column header and select Delete to remove the entire column from the file. Also check for hidden columns: right-click a column header, select Unhide, and delete any columns you do not need.
Should I use compression software like WinZip on my Excel file?
You can, but it is usually not necessary. Excel files already compress reasonably well on their own. If you need to email the file or upload it somewhere with a size limit, using a .zip archive will make it smaller, but the file itself will not change when you open it again.