Excel File Size Too Large? How to Reduce It

How-to basics · Updated November 19, 2026

To reduce a large Excel file, remove unused rows, columns, formatting, images, and duplicate data, then save a copy as an Excel Binary Workbook (.xlsb) if your workflow supports it. First identify what is making the workbook large: the best fix for oversized pictures is different from the best fix for excess formatting or stored data.

Why an Excel workbook gets large

A workbook’s size depends on more than the visible values in its cells. Excel also stores formulas, formatting, charts, pictures, PivotTable data, comments, objects, and sometimes imported or embedded files. A sheet that looks nearly empty can still contain formatting across thousands of unused rows, while a handful of high-resolution images can outweigh a large table of ordinary numbers.

File size and calculation speed are related only sometimes. A workbook with many complex formulas may calculate slowly without being especially large; a workbook full of pictures may be large but calculate quickly. Treat file size and performance as separate issues, and make a copy before removing data or changing how the workbook is stored.

Find what is taking up space

Start with a copy of the workbook and note its current size in File Explorer. If it contains several sheets, check each one rather than assuming the visible or active sheet is the problem. On Windows, press Ctrl+End on a sheet to jump to the last cell Excel considers used. On a Mac, Control+End generally serves the same purpose; on some compact keyboards, use Fn+Control+Right Arrow.

Compare that last cell with the actual edge of your data. If a sheet’s real data ends around row 500 but Ctrl+End lands at row 200,000, excess formatting or old content may be extending the used area. Also look for unusually large pictures, hidden sheets, repeated source tables, and PivotTables. Make a note of the file size after each major cleanup so you can tell which change helped.

  • Check whether the workbook contains image-heavy reports, logos, screenshots, or pasted pictures.
  • Look for empty-looking sheets with formatting or content far beyond the real data.
  • Review PivotTables, imported tables, hidden sheets, and embedded objects.
  • Check whether formulas or formatting have been copied much farther down or across than needed.

Remove unused rows, columns, and formatting

Excess formatting is a common reason a simple-looking workbook becomes unexpectedly large. For example, applying a fill color or border to entire columns can make Excel treat a much larger area as used than the visible table requires. Clear only the genuinely unused area: selecting cells that contain data, formulas, or useful formatting can damage the workbook’s layout.

  1. On the affected sheet, identify the first unused row below your real content and the first unused column to its right.
  2. Select the unused rows or columns extending to the sheet’s end. Use Home > Delete > Delete Sheet Rows or Home > Delete > Delete Sheet Columns. Deleting is generally more useful than merely pressing Delete, which clears cell contents but can leave formatting behind.
  3. Save the workbook, close it, and reopen it. Press Ctrl+End again to see whether Excel now recognizes a smaller used area.

If formatting is needed in the cells but not beyond them, select just the excess range and use Home > Clear > Clear Formats. This removes formatting without clearing values, but it also removes any intended number formats, fills, borders, and other appearance settings in the selected range. On Mac, ribbon names and placement can differ slightly; use the Home tab’s Clear controls where available.

Conditional formatting can also accumulate through repeated copying and pasting. Open Home > Conditional Formatting > Manage Rules, set the rules view to This Worksheet, and inspect for duplicate or needlessly broad rules. Remove only rules you understand: deleting a rule can change how important exceptions or warnings appear.

Compress pictures and remove oversized objects

Pictures are often the quickest source of a large size reduction. In Excel for Microsoft 365 on Windows, select a picture and choose Picture Format > Compress Pictures. If the dialog offers the choice, decide whether to compress only the selected picture or all pictures in the workbook. Selecting Delete cropped areas of pictures can reduce stored image data, but it means you may not be able to restore the cropped parts later.

Choose a resolution suitable for the workbook’s purpose. A spreadsheet viewed on screen usually does not need the same image detail as one intended for high-quality printing. Check the results at normal viewing size, especially for small text inside screenshots or charts. The precise compression options can vary by Office version and platform, so check the dialog before applying them; keep the uncompressed copy if image quality matters.

Also inspect for pictures, shapes, or objects that are hidden behind other content or placed far outside the visible report area. Delete only objects that are genuinely unnecessary. Pasted screenshots, scanned documents, and embedded files can be much larger than simple shapes, so replacing a large screenshot with a smaller, appropriately sized image may help more than changing cell formatting.

Reduce stored data and formula overhead

Look for duplicate copies of source data. A workbook may contain an imported data table, a second manually pasted copy, and a report built from that same information. If a copy is no longer needed, remove it only after checking that formulas, charts, PivotTables, or queries do not depend on it. Removing old rows from a source table can save space, but it can also change reports and calculations.

For completed historical periods, consider replacing formulas with their calculated values when the results no longer need to update. Select the relevant formula cells, copy them, then use Home > Paste > Paste Values. This removes the formulas but keeps their displayed results. It is not appropriate for live calculations, forecasts, or inputs expected to change. Keep a copy first, because pasted values do not preserve the original calculation logic.

Do not assume that every formula should be deleted or rewritten to save file size. Repeated formulas can be important, and complex formulas may be a performance concern rather than the main source of file size. If the workbook’s main problem is slow recalculation, investigate calculation and formula design separately instead of converting live results to fixed values just to make the file smaller.

Check PivotTables, connections, and hidden content

PivotTables may store source data inside the workbook so that the report can be used without immediately retrieving its source. If the source is large, that stored data can contribute to file size. On Windows, select a PivotTable and open PivotTable Analyze > Options, then inspect the Data tab for the Save source data with file setting. Turning this off may reduce stored data, but the PivotTable may need access to its source when refreshed. Confirm that the source will remain available before changing the option.

Workbooks can also contain hidden sheets, named ranges, comments or notes, and embedded objects that are no longer needed. Review these carefully rather than deleting them in bulk: a hidden sheet might hold a lookup table, and a named range may be used by a formula or validation rule. For workbooks that use queries or external connections, check whether data is being loaded both to a worksheet and to another destination. Avoid removing a connection until you know what uses it.

Save as XLSB or another format

Saving a copy as an Excel Binary Workbook can reduce file size without requiring you to remove workbook content. In Excel for Microsoft 365 on Windows, use File > Save As > Browse, then choose Excel Binary Workbook (*.xlsb) in the Save as type list. XLSB is a native Excel format and can store workbooks with macros; by contrast, the standard .xlsx format does not store VBA macros.

Test the saved copy before replacing the original. Check formulas, macros, charts, PivotTables, links, and any processes used by coworkers or other software. Some systems and workflows expect .xlsx, so a smaller .xlsb file is not automatically the better file to share. If you need a standard .xlsx, save in that format and use the other cleanup methods instead. Simply changing the file extension or putting an .xlsx file into another ZIP archive does not convert it into a more compact Excel workbook; .xlsx files already use a compressed package format.

Verify the result and avoid common mistakes

After cleanup, save the file under a new name, close Excel, and compare the new size with the original. Reopen the new file and test key outputs: totals, charts, refreshable reports, and any formulas or macros the workbook relies on. If the file is still large, return to the diagnosis rather than deleting more content at random. A large image or stored data cache may be responsible even after formatting is fixed.

Keep the original until you have verified the cleaned version and any required refreshes. Avoid clearing entire sheets, deleting hidden content without checking dependencies, or converting formulas to values across a live model. These actions can make a file smaller while silently making it incorrect. If a workbook is shared, coordinate format changes and data removal with the people and systems that use it.

Frequently Asked Questions

Why is my Excel file so large when it has little data?
A small visible table can sit in a sheet whose used range extends far beyond it, or the workbook may contain high-resolution pictures, stored PivotTable data, hidden objects, or excess formatting. Press Ctrl+End on each sheet and inspect pictures and reports as well as visible cells.

Does saving an Excel file as XLSB make it smaller?
It often does, but the amount varies with the workbook’s contents. Save a separate .xlsb copy and verify that your collaborators, macros, and other software support it before adopting the format.

Will deleting blank rows reduce Excel file size?
It can help when the rows contain leftover formatting or content that extends the used range. Delete only rows beyond the actual data, then save, close, and reopen the workbook to check whether Excel’s last used cell has changed.

Can I reduce file size without losing data?
Often, yes: compressing pictures, removing unused formatting, or saving a copy as .xlsb may help without deleting the data you need. However, compression can reduce image detail, and changing workbook formats can affect compatibility, so verify the copy.

Does converting formulas to values make a workbook smaller?
It can reduce formula content, especially when many formulas are no longer needed, but the values will no longer update. Use Paste Values only for results that are meant to stay fixed, and retain a backup of the formulas.

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.