Excel File Too Large? How to Make It Smaller in Excel

How-to basics · Updated November 19, 2026

To make a large Excel file smaller, first save a copy, then remove unused formatting and data, compress pictures, and reduce oversized PivotTable or query caches. Save the cleaned workbook as .xlsx or test .xlsb, and compare the file sizes; the best fix depends on what is taking up space.

Why an Excel workbook gets large

An Excel workbook can contain much more than the values visible in its cells. It may also store formulas, cell styles, conditional formatting rules, charts, images, PivotTable caches, Power Query data, connections, and embedded files. One oversized component can outweigh thousands of ordinary cells.

The .xlsx format is a compressed package, so a workbook with many repeated values may already be stored efficiently. A file that looks small in the grid can still be large if it contains high-resolution photographs, a copy of its source data inside a PivotTable cache, or formatting applied to huge unused ranges. Conversely, a workbook with many rows of simple text may not shrink dramatically through cleanup.

File size also depends on what you need the workbook to do. Removing formulas, source data, or embedded objects might reduce size, but it can also remove functionality. Decide whether the file must remain editable, refreshable, and visually identical before making changes.

Find what is taking up space

Start by checking the file size in File Explorer and noting the file type. Make a working copy with File > Save As before deleting content or changing formats. If the workbook is shared, tell collaborators that you are modifying a copy so their edits are not overwritten.

Then inspect the workbook for common size drivers:

  • Unusually large or growing worksheets: Press Ctrl+End on Windows to jump to Excel’s last used cell. If it lands far beyond the actual table, such as in row 900,000 when the data ends at row 8,000, the sheet may have an oversized used range. On Mac, Control+End is commonly used; on compact keyboards, Fn+Control+Right may be needed.
  • Pictures and objects: Look for large photos, pasted screenshots, logos, and embedded documents. Pictures are easy to overlook when they sit behind cells or on a hidden sheet.
  • PivotTables and queries: Check whether the workbook contains several PivotTables, loaded query results, or connections that are no longer needed. Open Data > Queries & Connections to review queries and connections.
  • Multiple copies of data: Check for hidden worksheets, duplicate imports, old versions of tables, and unused sheets. Hidden content still contributes to the workbook.

There is no built-in Excel command that reports a complete size breakdown for every workbook component. A practical approach is to save a copy after each major cleanup and compare its size in File Explorer. That helps identify which change made a difference and makes it easier to undo a choice by returning to the original.

Remove excess rows, columns, and formatting

Unnecessary formatting can inflate a workbook even when the cells look blank. If Ctrl+End lands well beyond your real data, inspect the intervening rows and columns. Formatting, borders, validation, or conditional formatting may have been applied far down a sheet.

  1. On the affected worksheet, identify the first row below your actual data and the first column to its right. Confirm that no formulas, notes, or content you need are there.
  2. Select the unused rows or columns by their row or column headers. Use Home > Clear > Clear All to remove their contents and formatting, or Home > Clear > Clear Formats if the formatting is the problem but you need to preserve content.
  3. Save the workbook, close it, and reopen it. Press Ctrl+End again to check whether Excel’s last used cell has moved closer to the real data.

Be cautious with deleting entire rows or columns: formulas, charts, named ranges, and other sheets may refer to them. Clearing formatting is often a safer first step. Also remove excess conditional formatting through Home > Conditional Formatting > Manage Rules, checking the current worksheet and other sheets as needed. Rules copied across enormous ranges can make a workbook slower as well as larger.

Do not delete blank-looking cells blindly. A cell may contain a formula that returns an empty string, or it may be part of a template that someone still uses. If the sheet has a defined input area, preserve it and focus on ranges well outside that area.

Compress pictures and remove embedded objects

Pictures are often the fastest way to reduce a workbook’s size, especially when photographs were pasted at full camera resolution. Select a picture, open Picture Format > Compress Pictures, and choose whether to apply the change to the selected picture or all pictures. Clear the option to apply only to the selected picture if you want to compress every picture in the workbook. If you do not need to restore the original crop later, select the option to delete cropped areas of pictures.

Choose an output resolution that suits the workbook’s purpose. A sheet viewed on screen usually does not need print-quality source photographs, but a workbook intended for high-quality printing may. Compression can reduce image clarity, so inspect important images and compare the result before replacing the original. The exact labels and available resolution choices can differ by Office version. On Mac, select a picture and look for the compression controls on the Picture Format tab; ribbon layout can vary by version.

Also review objects such as pasted PDFs, audio or video files, and other embedded documents. If an object is no longer needed, select and delete it. If readers only need to see its contents, consider replacing it with a small image or a link to the original file. A link keeps the workbook lighter but depends on the linked file remaining available to the people who use the workbook.

Reduce formula and data duplication

Formulas themselves occupy space, and large formula-filled ranges can add up. If a worksheet is a finished report rather than a live calculation model, you may be able to replace selected formula results with fixed values. Select the appropriate range, copy it, then use Home > Paste > Paste Special > Values. This keeps the displayed results but removes the formulas from those cells.

That change is irreversible after the workbook is saved unless you retain an original copy. It also means the results will no longer update when the inputs change. Keep formulas in working or audit sheets when readers need to see how results were calculated. Converting every formula to a value is not a general-purpose size fix: it sacrifices calculation and can make the workbook harder to maintain.

Look for duplicated source tables or repeated imported data before changing formulas. If a report contains several copies of the same raw data, retaining one source table and building reports from it may save space. However, changing a model’s structure can affect references, PivotTables, and automation, so verify dependent sheets after cleanup.

Check PivotTable caches, queries, and connections

A PivotTable can store a copy of its source data in a cache so it can be used without immediately rereading the original range. This is convenient, but a large source table can make the workbook much bigger. Select a PivotTable and open PivotTable Analyze > Options, then look on the Data tab for the setting to save source data with the file. Clearing that setting may reduce the saved workbook, but users may need access to the original source to refresh the PivotTable. Test refresh behavior before distributing the file.

Do not assume every PivotTable has a separate cache or that removing one cache is always safe. PivotTables may share a cache, and workbooks using the Data Model have different storage and refresh considerations. If the workbook depends on offline access or must refresh on a colleague’s computer, retaining the source data may be more important than reducing file size.

Review Data > Queries & Connections for obsolete queries or connections. Remove only those you recognize and no longer need. A query may be supplying a table, chart, or report elsewhere in the workbook; deleting it can break the refresh process or remove its output. If a query’s result is needed but its source connection is not, decide how the workbook should be maintained before removing either part.

Choose a smaller file format carefully

For most modern workbooks, .xlsx is a good default. It is a compressed, widely supported format, but changing an already-saved .xlsx file to .xlsx again will not usually produce a dramatic reduction. Excel Binary Workbook (.xlsb) can be smaller or faster to open for some data-heavy workbooks. Use File > Save As and choose Excel Binary Workbook (*.xlsb), then compare the saved copy with the original.

.xlsb is not automatically smaller in every case, and some systems or third-party tools handle it less conveniently than .xlsx. If the workbook contains macros, .xlsb can store them, but .xlsm is another macro-enabled option. Choose a format that preserves required features and works for the people and software that need to open the file. Test important formulas, macros, connections, and charts after saving in a different format.

CSV is an option only when you need a plain data export, not a complete Excel workbook. A CSV file stores one sheet of text and values; it does not preserve workbook formatting, formulas as formulas, charts, PivotTables, or multiple worksheets. The older .xls format is generally not a useful size-reduction choice and has restrictive worksheet limits. Do not rename a file extension to try to convert it; use Save As.

Keep future workbooks manageable

A few habits help prevent a workbook from growing unnoticed. Import only the columns and date ranges needed for the analysis, avoid applying formatting to whole worksheets without a reason, and remove temporary copies of source data when they are no longer required. Keep original photographs outside the workbook if readers do not need the full-resolution files inside it.

When a workbook is used as a long-term reporting tool, separate raw data, calculations, and presentation where practical. That can make it easier to identify what must stay editable and what can be exported as values. It is also worth periodically checking hidden sheets, obsolete queries, and the last used cell on sheets that have been heavily edited.

If Excel becomes slow as well as the file becoming large, consider whether the workbook is doing more work than it needs to. Unnecessary formulas and oversized conditional-formatting ranges can affect responsiveness even when they are not the main source of megabytes. File size and calculation speed are related sometimes, but they are not the same problem.

Frequently Asked Questions

Why is my Excel file so large with very little data?
A small visible table can sit in a workbook that also stores high-resolution pictures, formatting on unused cells, hidden sheets, embedded files, or a large PivotTable cache. Press Ctrl+End on Windows to check whether Excel considers cells far beyond your table part of the used range, and review pictures and queries as well.

Does saving an Excel file as .xlsx make it smaller?
Not necessarily. .xlsx is already a compressed workbook format, so resaving a file that is already .xlsx may make little difference. Cleanup or a comparison with .xlsb is more likely to help when the workbook contains large amounts of data, although results vary.

Can I delete blank rows to reduce Excel file size?
Sometimes, but blank-looking rows may contain formatting, formulas, or template areas. Check what is actually used, clear unnecessary formatting or content, then save, close, and reopen the workbook. Keep a copy first and verify that formulas and references still work.

Will compressing pictures make them blurry?
It can. Compression reduces image data, and lower resolution can be noticeable when an image is enlarged or printed. Keep an untouched copy, choose a resolution that fits the workbook’s use, and inspect the compressed pictures before sharing the file.

Is it safe to convert formulas to values?
It is safe only if you no longer need those cells to recalculate. Paste Special > Values keeps the current displayed results but removes the formulas, so changes to inputs will not update them. Preserve a copy of the formula-based workbook if calculations may be needed later.

What if the workbook is still too large to email?
First check your email provider’s attachment limit, which varies. After making a copy and cleaning the workbook, you can share it through an approved cloud-storage service instead of attaching it. A link avoids some attachment limits, but access permissions and the recipient’s ability to open the file still matter.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.