Why Excel Files Get Large and What You Can Actually Do About It

Excel files balloon when they contain images, complex formatting, hidden rows or columns, or data you stopped using months ago. A spreadsheet with a few thousand rows and some charts might be 2 or 3 megabytes. One with embedded images, multiple sheets of old calculations, or formatting applied to thousands of empty cells can hit 10 or 20 megabytes. The file still opens and works, but it slows down, takes longer to email, and uses more cloud storage.

You can shrink an Excel file without deleting the data you need. The most effective methods are removing images or converting them to lower resolution, deleting unused sheets and hidden rows, clearing unnecessary formatting, and saving in the right file format. Most take five to fifteen minutes.

Key Takeaways

  • Images are usually the largest part of an Excel file — removing them or replacing them with lower-resolution versions saves the most space.
  • Hidden rows, columns, and sheets still take up file size, so deleting them rather than hiding them actually reduces the file.
  • Saving as .xlsx (the default format) is smaller than .xls, and removing all formatting from empty cells cuts size further.
  • Splitting a large workbook into separate files by year or department often works better than trying to compress one massive file.

Remove or Compress Images Embedded in Your Spreadsheet

Images are almost always the reason an Excel file is unexpectedly large. A single photograph can be 500 kilobytes to 2 megabytes. If your spreadsheet has five or ten images, they account for most of the file size.

To find out: right-click on an image in your spreadsheet and select Format Picture (or Format Image in newer versions). The dialog shows the image's current resolution. If it is 1920 by 1080 pixels or larger, it is much bigger than necessary for a spreadsheet. You have two options: delete the image if you do not need it, or compress it.

To compress an image without deleting it, right-click it and choose Compress Pictures. A dialog appears with resolution options. Select Screen (96 dpi) or Email (150 dpi) instead of Print (220 dpi). This reduces the image to a size that looks fine on screen but takes up a fraction of the space. Click OK. Repeat for each image in the file.

If you have many images, this method works but takes time. A faster approach is to delete all images, save the file, and then re-insert only the ones you actually need — compressed from the start.

Delete Hidden Rows, Columns, and Sheets You Are Not Using

Hidden rows and columns still count toward file size. If someone hid rows 50 through 500 to clean up the view, those rows are still in the file taking up space. The same is true for hidden sheets — they are still stored in the workbook.

To find hidden rows or columns, select all cells by clicking the box at the top left corner where the row numbers and column letters meet. Right-click and choose Unhide. Any hidden rows or columns will reappear. Look through them. If they contain old data you no longer need, select them again, right-click, and choose Delete instead of hiding them again.

For hidden sheets, right-click on any sheet tab at the bottom of the window and select Unhide. A dialog lists all hidden sheets. Select one and click OK to make it visible. If the sheet is empty or contains outdated information, right-click its tab and choose Delete Sheet. Confirm the deletion.

Deleting rather than hiding removes the data from the file entirely, which is why it reduces size. Hiding just makes it invisible.

Clear Formatting From Empty Cells and Unused Areas

Excel stores formatting information for every cell, even empty ones. If you applied a background color, border, or font style to a large range of cells and then deleted the data, the formatting remains. This does not add much size on its own, but across thousands of cells it adds up.

To clear unnecessary formatting, select the range of cells where you no longer need it. You can select a whole column by clicking its letter, or a whole sheet by clicking the select-all box. Go to the Home tab, click the arrow next to Clear, and choose Clear Formats. This removes all formatting but keeps any data that is still there.

A more aggressive approach: select all cells, go to Home > Clear > Clear All, then re-enter only the data and formatting you actually use. This is worth doing if your file has years of accumulated formatting from old edits.

Save in the Right Format and Remove External Links

Excel offers several file formats. The default, .xlsx, is smaller than the older .xls format. If your file is still saved as .xls, converting it to .xlsx will reduce size when ready.

To convert, open the file and go to File > Save As. In the Save as type dropdown, select Excel Workbook (.xlsx). Click Save. The file is now in the smaller format.

External links — formulas that pull data from other files — also add to file size. To find them, go to Data > Edit Links (or Queries & Connections in newer versions). If you see links to files you no longer use, select them and click Break Link. This converts the linked formulas to their current values, removing the external reference and reducing file size.

Split Large Workbooks Into Separate Files

If your spreadsheet contains data from multiple years, departments, or projects, splitting it into separate files often works better than trying to compress one massive workbook. A file with five years of sales data in separate sheets can become five smaller files, each easier to open, email, and manage.

To split a workbook, create a new Excel file for each section. Copy the relevant data from the original file into each new file. Delete the sheets you do not need from each new file. Save each one with a clear name — for example, Sales_2023.xlsx, Sales_2024.xlsx. Delete the original large file once you have confirmed all the data is in the new files.

This approach also makes it easier to share only the data someone needs. Instead of sending a 15-megabyte file with everything, you send a 2-megabyte file with only their department's information.

Use Compression Tools as a Last Resort

After removing images, deleting hidden content, and clearing formatting, your file should be noticeably smaller. If it is still too large, you can compress the entire file using a tool like 7-Zip or WinRAR (on Windows) or the built-in Archive Utility (on Mac). This creates a .zip file that is smaller than the original.

The downside: you have to unzip the file before you can open it in Excel. This adds a step every time you need to use it. Compression is useful for archiving old files you rarely open, but not for files you work with regularly.

To compress on Windows, right-click the Excel file, select Send to, and choose Compressed (zipped) folder. On Mac, right-click the file and select Compress. Both create a .zip version that is smaller than the original.

Frequently Asked Questions

Will reducing file size affect my formulas or data?

No, as long as you delete only images, hidden content, and formatting. Formulas and the actual data in cells remain unchanged. Removing images or compressing them does not touch the numbers or text you need.

How much smaller will my file get?

It depends on what is in it. Removing images usually saves the most — often 50 to 80 percent if your file has several photos. Deleting hidden rows and clearing formatting saves less, usually 5 to 20 percent. The actual amount varies by file.

Can I undo these changes if I delete something by mistake?

Yes, when ready after deleting, press Ctrl+Z (or Cmd+Z on Mac) to undo. This works for most deletions. If you have already saved and closed the file, undo will not work, so save a backup copy before making large changes.

What if my file is still too large after trying these methods?

Split the file into smaller workbooks by year, department, or project. This is often faster than trying to squeeze more size out of a single massive file, and it makes the files easier to use day to day.