The fastest ways to shrink an Excel file

Excel files grow large because they store formatting, hidden rows, unused columns, and images at full resolution. The quickest fixes are deleting blank rows and columns, removing images or compressing them, clearing formatting from empty cells, and saving in the right format. Most files shrink by 20 to 50 percent with these steps alone.

If your file is still large after cleanup, you can split it into separate workbooks, convert it to CSV format (which removes all formatting), or use Excel's built-in compression tools. The method you choose depends on whether you need to keep the file as a working spreadsheet or just preserve the data.

Key Takeaways

  • Delete entirely blank rows and columns, then save the file — this removes formatting data Excel stores even in empty cells.
  • Compress or remove images by right-clicking them, selecting Compress Pictures, and choosing the lowest resolution you can use.
  • Clear formatting from cells you are not using by selecting them, then pressing Delete to remove formatting without removing formulas.
  • Save as .xlsx (Excel 2007 format) instead of .xls, which is older and stores data less efficiently.
  • If the file stays large after cleanup, convert it to CSV format, which removes all formatting but keeps the raw data.

Delete blank rows and columns

Excel stores formatting information for every cell in a used range — the rectangle from the top-left cell with data to the bottom-right cell with data. If you have data in column A and column Z but nothing in between, Excel still stores formatting for every column in that range. The same applies to rows.

To shrink the used range, select a blank row by clicking its row number on the left, then right-click and choose Delete. Do this for every entirely blank row. Repeat for blank columns by clicking the column letter at the top, right-clicking, and choosing Delete. After you delete rows and columns, save the file — this updates the used range and removes the formatting data.

You can also use Go To Special to find and delete blank cells in bulk. Press Ctrl+H (or Cmd+H on Mac), click Options, then Find & Replace. Search for ^$ (which finds empty cells), leave Replace blank, and click Replace All. This removes content from empty cells but keeps the used range the same size, so delete the rows and columns afterward.

Compress or remove images

Images are often the largest part of an Excel file. Right-click any image in your spreadsheet and select Compress Pictures. A dialog box opens with resolution options — choose the lowest resolution that still looks acceptable for how you use the file. If the image is only for reference and does not need to be sharp, select 96 ppi (pixels per inch), which is screen resolution. If you print the file, use 150 ppi.

If you have many images, you can remove them entirely and save the file as a separate PDF or image file instead. Select all images by clicking one, pressing Ctrl+A to select all objects, then press Delete. This removes them from the spreadsheet but you still have the originals on your computer.

Clear formatting from unused cells

Excel stores formatting (colors, fonts, borders, number formats) for cells even if they are empty. If you have formatted a large area and then deleted the content, the formatting remains and makes the file larger. To remove it, select the range of cells, then press Delete. This clears formatting without removing any formulas or data you want to keep.

You can also select a range and use Clear Contents (Ctrl+Minus on Windows, Cmd+Minus on Mac) to remove everything including formatting. If you only want to remove formatting and keep data, select the range, go to Home tab, click Clear, and choose Clear Formats.

Save in the right file format

Excel has several file formats, and some are more efficient than others. The .xlsx format (Excel 2007 and later) compresses data better than the older .xls format. If your file is .xls, save it as .xlsx: go to File, click Save As, change the file type dropdown to Excel Workbook (.xlsx), and click Save.

If you do not need formulas, formatting, or multiple sheets, save as CSV (Comma Separated Values) instead. This removes all formatting and reduces file size dramatically — often to 10 percent of the original. Open File, click Save As, change the type to CSV UTF-8 (.csv), and click Save. You lose formatting and formulas, so only use this if you are archiving data or sharing raw numbers.

Split large files into separate workbooks

If your file has multiple sheets and is still large after cleanup, move some sheets to a separate workbook. Right-click a sheet tab at the bottom, select Move or Copy, choose New Book, and click OK. This creates a new file with that sheet. Save the new file with a descriptive name. Repeat for other sheets until each workbook is a manageable size.

This approach works well if different people use different sheets or if you archive old data separately. You can keep a summary sheet in the main file that links to the other workbooks using formulas, so changes in one file update the summary automatically.

Use Excel's built-in compression tools

Excel 2016 and later have a Compress Pictures feature that works on all images at once. Go to File, click Info, then click Compress Pictures. Choose your resolution and click OK. This compresses every image in the workbook without opening each one individually.

You can also remove unused formatting styles. Go to Home tab, click the arrow under Cell Styles, right-click any style you do not use, and select Delete. This removes the style definition from the file. If your file has many custom styles you created and then stopped using, this can save space, though the effect is usually small compared to removing images or blank rows.

Frequently Asked Questions

Why is my Excel file so large when it only has a few rows of data?

The file likely contains images, or the used range extends far beyond your data. Check for images by scrolling through the sheet. If there are none, press Ctrl+End to jump to the last cell Excel thinks contains data — if it is far from your actual data, you have blank rows or columns with formatting. Delete them and save.

Will saving as CSV lose my formulas?

Yes. CSV format stores only values, not formulas or formatting. If you need formulas, save as .xlsx instead. If you only need the numbers for reference or sharing, CSV is fine and much smaller.

Can I undo a file size reduction?

Partially. If you deleted rows or columns by mistake, undo with Ctrl+Z immediately. If you compressed images, the original high-resolution versions are gone — keep a backup before compressing. Clearing formatting cannot be undone after you save, so save a copy first if you are unsure.

What if my file is still huge after I delete images and blank rows?

Check for hidden rows or columns by selecting all cells (Ctrl+A), right-clicking, and choosing Unhide. If many rows or columns appear, delete the ones you do not need. You can also try opening the file in a different program — sometimes Excel files become bloated from repeated edits, and opening and resaving in Google Sheets or LibreOffice can reduce size.

Is there a file size limit in Excel?

Excel files can be up to 2 GB in theory, but files over 100 MB often become slow and difficult to work with. If your file is approaching that size, split it into separate workbooks or consider using a database instead of a spreadsheet.