Why Excel files grow and what actually takes up the space

Excel files balloon for reasons that have nothing to do with how many rows of data you see. The most common culprit is formatting applied to empty cells — when you format a whole column or sheet, Excel remembers that formatting even in cells you never used. A second major cause is images and charts embedded in the file, which can easily be several megabytes each. A third is hidden rows, columns, or sheets that you forgot about but Excel still carries. The fourth is undo history — Excel stores every change you made, and that history can grow to 50 MB or more in a file you've worked on for months.

Before you start deleting things, open your file and check its actual size. Right-click the file in Windows File Explorer (or use Finder on Mac), select Properties, and note the file size in bytes or megabytes. After you explore each fix below, save the file and check the size again. This tells you which steps actually helped and which ones made no difference for your particular file.

Key Takeaways

  • Delete or compress images and charts first — these usually account for the largest portion of file size.
  • Clear undo history by saving the file, closing it, and reopening it, which removes all stored changes from memory.
  • Remove hidden rows, columns, and sheets by unhiding them, selecting them, and deleting them permanently.
  • Delete formatting from empty cells by selecting unused areas and clearing formatting without deleting the cells themselves.
  • Save as .xlsx (the default Excel format) rather than .xls, which uses older compression and creates larger files.

Delete or compress images and charts embedded in the sheet

Images are almost always the reason an Excel file is unexpectedly large. A single photograph can be 2 to 5 MB. If your file contains charts, logos, or screenshots, start here.

Open the file and look at each sheet. Click on any image or chart to select it, then look at the bottom right of your screen — Excel shows the file size of that object. If you see images you don't actually need, select them and press Delete. If you need the images but want them smaller, right-click each one and choose Compress Pictures (in Excel on Windows) or Format Picture (on Mac). A dialog will appear asking what resolution you want — choose Screen (150 dpi) for anything that will only be viewed on a computer, or Print (220 dpi) if the sheet will be printed. This usually cuts image file size in half or more.

For charts, the file size is usually not the chart itself but any background images or data tables linked to it. Right-click the chart, select Edit Data, and delete any columns you don't need displayed. Then click outside the chart to finish editing.

Clear the undo history by saving and reopening

Excel stores every single change you made to the file in its undo history. If you've been working on a file for weeks, that history can be 50 MB or larger. You cannot delete the undo history directly through a menu — instead, you force Excel to discard it by closing and reopening the file.

Save your file (Ctrl+S on Windows, Command+S on Mac). Close the file completely. Then reopen it. When you reopen it, Excel discards all the stored undo history and starts fresh. This single step often shrinks a file by 10 to 30 percent if you've been editing it heavily.

Find and delete hidden rows, columns, and sheets

Hidden rows and columns take up almost no space, but hidden sheets can be substantial if they contain data. To find them, right-click on any row number (the gray area on the left side of the sheet) and select Unhide. Do the same for columns by right-clicking on any column letter. If rows or columns appear, select them all and delete them if you don't need them.

For hidden sheets, right-click on any sheet tab at the bottom of the window and select Unhide. A dialog will show all hidden sheets. Select each one, click OK, then right-click the sheet tab again and choose Delete Sheet if you don't need it. If you do need the data but not the sheet visible, leave it hidden — hidden sheets take up minimal space.

Remove formatting from empty cells and unused areas

When you format an entire column or row — changing the background color, font, borders, or number format — Excel applies that formatting to every single cell in that column or row, even the ones you never touched. Over time, this adds up.

Identify the area where your actual data ends. If your data goes to row 100 and column F, select from row 101 to the bottom of the sheet (click row 101, then press Ctrl+Shift+End on Windows or Command+Shift+End on Mac). Right-click and choose Clear Contents. This removes all formatting from empty cells without deleting the cells themselves. Repeat for columns to the right of your data.

Save the file in the correct format

Excel has several file formats. The modern default is .xlsx, which uses compression. Older files saved as .xls use a less efficient compression method and are often 20 to 40 percent larger than the same data saved as .xlsx.

If your file is currently .xls, open it and go to File > Save As. In the dialog, change the file type dropdown to Excel Workbook (.xlsx). Click Save. Excel will ask if you want to keep the new format — click Yes. The file will now be smaller and will open faster.

Do not save as .xlsm (macro-enabled) unless your file contains macros you actually use. Do not save as .csv or .txt — these formats lose all formatting and charts, and they're not designed for large files.

Use the built-in file compression tool in newer Excel versions

If you're using Excel 2016 or later on Windows, you have access to a compression tool. Go to File > Info. Look for a button that says Reduce File Size (it may be under a Tools or Optimize section depending on your version). Click it, select the images in your file, and choose your desired resolution. This is the same as right-clicking images individually, but faster if you have many.

On Mac, this feature is not available in the same way. Instead, use the compress images method described earlier, or consider opening the file in Excel on Windows if you have access to both.

Frequently Asked Questions

Will reducing file size change my data or formulas?

No. Deleting images, clearing undo history, and removing formatting from empty cells do not touch your actual data or any formulas. The numbers, text, and calculations remain exactly the same. Deleting hidden rows or columns will remove data only if those rows or columns contained information you needed.

What if I need to keep the images but the file is still too large?

Compress the images to Screen resolution (150 dpi) as described above — this is the most effective step. If the file is still large, move the images to a separate document and link to them instead of embedding them. This requires more setup but can reduce file size dramatically if you have many high-resolution images.

Can I undo the changes if I make a mistake?

Yes, as long as you haven't closed the file. If you delete a row or column by accident, press Ctrl+Z (or Command+Z on Mac) when ready to undo. If you've already closed the file, you cannot undo — which is why it's wise to save a backup copy before making large deletions.

Why is my file still large after I've done all these steps?

The most likely reason is that your actual data is genuinely large — you have thousands of rows with complex formulas or many sheets. In this case, consider splitting the file into separate files by year or category, or moving old data to an archive file you keep separate from your working file.

Should I delete blank rows at the end of my data?

Blank rows at the end take up almost no space. What matters is whether they have formatting applied. If you've formatted entire columns or rows, clear that formatting as described above. If the rows are truly blank with no formatting, leaving them does not meaningfully increase file size.