Why Excel files grow large and what you can do about it
Excel files balloon in size when they contain formatting you no longer need, hidden rows and columns, unused worksheet tabs, or images that haven't been compressed. A spreadsheet with a few thousand rows of data might be 500 KB, but the same data with old formatting, deleted content still taking up space, and uncompressed images can easily become 10 MB or more. The file becomes slower to open, harder to email, and takes up unnecessary storage.
You can shrink an Excel file without losing your actual data by removing what's invisible but still taking up space. Most of these fixes take a few minutes and work in Excel 2016 and later on both Windows and Mac.
Key Takeaways
- Delete unused worksheet tabs, hidden rows and columns, and empty cells with formatting to recover space when ready.
- Compress images inside your spreadsheet to a resolution that matches how you actually use them.
- Clear formatting from cells you no longer need, especially if you've copied and pasted content many times.
- Save your file as .xlsx (the default format) rather than .xls, which stores data less efficiently.
- Use the Inquire tool in Excel (Windows only) to see exactly what's taking up space in your file.
Remove unused worksheet tabs and hidden content
Worksheet tabs at the bottom of your screen are often left over from earlier versions of the file. Right-click any tab you don't need and select Delete. Excel will ask you to confirm; click Delete again. Do this for every tab except the ones you actually use.
Hidden rows and columns also take up file space even though you can't see them. To find and remove them, select all cells by clicking the box where the row numbers and column letters meet (the top-left corner). Right-click and choose Unhide to reveal any hidden rows or columns. Once they're visible, you can decide whether to delete them. If they contain data you want to keep, leave them unhidden but move that data to a visible location instead.
Empty cells with formatting — cells that have a background color, border, or font style but no actual data — also add to file size. Select the range of cells you know are empty, right-click, and choose Clear Contents. This removes the formatting but leaves the cells available if you need them later.
Compress images embedded in your spreadsheet
A single high-resolution photo can add 1 MB or more to your file. If your spreadsheet contains images, right-click any image and select Compress Pictures (on Windows) or Reduce File Size (on Mac). A dialog box will open with resolution options.
Choose the resolution based on how the file is used. If the spreadsheet is only viewed on screen and emailed, select Screen (150 ppi). If it's printed, use Print (200 ppi). If the image is just a small logo or icon, E-mail (96 ppi) is usually fine. Click OK and the image will shrink without noticeably changing how it looks in your spreadsheet.
If you have many images, you can compress them all at once. Select the first image, then hold Ctrl (Windows) or Cmd (Mac) and click each additional image to select them together. Then right-click and compress as described above.
Delete rows and columns you no longer use
If your spreadsheet has data in columns A through D but columns E through Z are empty, select those empty columns by clicking the column letter, then right-click and choose Delete. The same applies to rows: if your data ends at row 500 but the sheet extends to row 1,048,576 (the maximum), those empty rows still take up space in the file.
To find where your actual data ends, press Ctrl+End (Windows) or Cmd+End (Mac). Excel will jump to the last cell that contains data or formatting. Everything beyond that point can be deleted. Select from that cell to the end of the sheet, right-click, and choose Delete Sheet Rows or Delete Sheet Columns.
Save in the right format and use Save As to clean up
Excel's default format is .xlsx, which compresses data more efficiently than the older .xls format. If your file is saved as .xls, open it and go to File > Save As. In the format dropdown, select Excel Workbook (.xlsx) and click Save. This alone can reduce file size by 20 to 30 percent.
Using Save As instead of regular Save can also help. When you use Save As, Excel writes a completely fresh copy of the file, which sometimes removes invisible overhead that accumulates over time. Open the file, go to File > Save As, give it the same name (or a new one), and save it as .xlsx. The new copy is often noticeably smaller than the original.
Use the Inquire tool to see what's taking up space
If you're working in Excel on Windows, the Inquire tool shows you exactly what's consuming space in your file. Go to File > Options > Trust Center > Trust Center Settings > Trusted Documents. Check the box for Allow Trusted Documents, then close the dialog.
Now go to the Review tab and look for Inquire (it may be under a dropdown menu labeled Inquire). Click Workbook Analysis. A new window opens showing a breakdown of what's in your file: how many cells contain data, how many have formatting only, how many images are present, and more. This tells you exactly where to focus your cleanup effort.
On Mac, this tool is not available, but you can still use the other methods above to reduce file size.
Frequently Asked Questions
Will shrinking my Excel file change my data or formulas?
No. Removing unused tabs, hidden rows, empty formatted cells, and compressing images does not change any data or formulas you actually use. The spreadsheet will work exactly the same way, just in a smaller file.
How much smaller will my file get?
It depends on what's in the file. Removing a few unused tabs might save 10 to 50 KB. Compressing images can save 500 KB to several MB. Converting from .xls to .xlsx might save 20 to 30 percent of the total size. Most files shrink by 30 to 50 percent after a full cleanup.
Can I undo these changes if I delete something by mistake?
Yes, as long as you haven't closed the file. Press Ctrl+Z (Windows) or Cmd+Z (Mac) to undo your last action. If you've closed the file, you can't undo, so it's wise to make a copy before you start deleting.
What if my file is still huge after I've done all this?
The file may contain a very large amount of actual data, which is normal. If you need to send it by email, consider splitting it into multiple files by date or category, or ask the recipient if they can receive it through cloud storage instead.