Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →The safest way to shrink an Excel workbook is to make a backup, identify what is consuming space, then remove unused cells, formatting, media, cached data and model fields one category at a time. In Microsoft 365 Excel, start with Review > Check Performance; for image-heavy files, compress pictures; for PivotTables and data models, reduce stored source data; and save a compatible copy as .xlsb when appropriate. Reopen, recalculate and refresh the reduced copy before replacing the original.
Start with a controlled copy
Save the original workbook under a new name before changing anything. Keep the untouched file until the smaller copy has passed a full functional check. Work on the copy locally, record its initial file size, and save after each major cleanup category. A size change after each save tells you which component is responsible for the bloat and makes it possible to undo one decision without rebuilding the workbook.
As an Amazon Associate I earn from qualifying purchases.
- Use a descriptive name such as
Report_reduced_2026-10-18.xlsxso the original is not overwritten accidentally. - Close other copies of the workbook before measuring its size; temporary lock files are not the workbook itself.
- Note whether the file contains macros, external links, Power Query queries, Power Pivot, PivotTables, images or special artwork. Those features determine which reductions are safe.
- After every substantial change, use the operating system’s file properties to record the new size. Excel’s displayed workbook information is not always the same as the on-disk size.
Find what is making the workbook large
Isolate sheets and objects
There is no reliable percentage reduction that applies to every workbook. A file dominated by photographs responds to picture compression; one dominated by unused formatted cells responds to a used-range cleanup; and a workbook with a large PivotTable cache or data model needs a different treatment. To locate the cause, make a working copy and temporarily remove or copy components one at a time:
- Save the baseline copy and note its size.
- Duplicate the workbook, remove one suspect sheet or object category, and save.
- Compare the saved file size with the baseline.
- Undo or discard that test copy, then test the next category.
Large jumps point to the area worth cleaning first. Test sheets that contain many pictures, long histories, PivotTables, query outputs or extensive formatting before spending time on ordinary formula cells.
#1 Best Overall
- Classic Office Apps | Includes classic desktop versions of Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, and presentations with ease.
- Install on a Single Device | Install classic desktop Office Apps for use on a single Windows laptop, Windows desktop, MacBook, or iMac.
- Ideal for One Person | With a one-time purchase of Microsoft Office 2024, you can create, organize, and get things done.
- Consider Upgrading to Microsoft 365 | Get premium benefits with a Microsoft 365 subscription, including ongoing updates, advanced security, and access to premium versions of Word, Excel, PowerPoint, Outlook, and more, plus 1TB cloud storage per person and multi-device support for Windows, Mac, iPhone, iPad, and Android.
Use Check Performance in Microsoft 365 Excel
Supported Microsoft 365 desktop builds include a performance inspection command at Review > Check Performance. Excel lists cells it considers optimizable, including cells with no data that still occupy space because they contain formatting, blanks or non-printing characters.
- Open the backup copy in a supported Microsoft 365 edition.
- Choose Review, then Check Performance.
- Inspect the optimizable-cell list sheet by sheet. Confirm that a highlighted region is not intentional blank formatting, a template area, a print layout or Pixel Art.
- Choose Optimize sheet for a reviewed sheet or Optimize all only after checking the listed regions.
- Save, close and reopen the workbook, then inspect the affected sheets.
Microsoft warns that optimization can remove cells used for Pixel Art. Do not run it blindly on a workbook that deliberately uses colored blank cells as artwork or as a visual template. If the command is absent, use the manual used-range and formatting checks below; availability depends on the Excel build and license.
Remove unused data and sheets
Delete content that no feature still needs
Microsoft Support states, “Removing unused data will reduce your file size.” Delete obsolete worksheets, old exports, staging ranges and duplicate tables only after checking what depends on them.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problems- Search formulas for references to the sheet or range before deleting it.
- Review defined names, data validation lists, conditional-formatting formulas and chart series; these can point to cells that appear unused.
- Check external links, queries and connections. A query may use a staging sheet even when no visible formula does.
- Inspect PivotTable source ranges and caches. Removing a source table without changing the PivotTable can break refresh.
- Review VBA macros and buttons. Macro code can refer to a worksheet by name, index or hard-coded range.
When a table is no longer needed, delete the entire worksheet rather than clearing visible values while leaving a large formatted area behind. If historical data must be retained for audit purposes, move it to a separate archive workbook and document that separation rather than keeping a hidden copy in the active report.
Trim expanded used ranges
A worksheet can have a used range far beyond its real data because someone formatted entire columns, pasted a block and cleared the values, or left non-printing characters behind. Those empty-but-formatted cells consume space and can slow opening and editing.
Rank #2
![Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]](https://m.media-amazon.com/images/I/41H8B5iqO4L._SL160_.jpg)
- [Ideal for One Person] — With a one-time purchase of Microsoft Office Home & Business 2024, you can create, organize, and get things done.
- [Classic Office Apps] — Includes Word, Excel, PowerPoint, Outlook and OneNote.
- [Desktop Only & Customer Support] — To install and use on one PC or Mac, on desktop only. Microsoft 365 has your back with readily available technical support through chat or phone.
- On each suspect sheet, press
Ctrl+Endto see the last cell Excel considers used. - Compare that location with the true last row and column of the dataset.
- Select rows below the real end and columns to the right of the real end.
- Use Home > Delete > Delete Sheet Rows or Delete Sheet Columns, not merely the Delete key, to remove the extra cells and their formatting.
- Save, close and reopen the workbook, then press
Ctrl+Endagain to confirm the used range contracted.
Do not delete blank rows or columns that are part of an intentional input form, print layout, protected template or chart area. Check named ranges and formulas that intentionally reserve space before removing anything.
Clean up formatting and drawing objects
Remove accidental formatting and duplicate styles
Excessive formatting can increase file size and hurt performance. Common causes include applying a style to a whole million-row column, repeatedly copying cells from other workbooks, and accumulating near-identical custom styles.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Restrict borders, fills, number formats and conditional formatting to the actual data range.
- Remove formatting from genuinely unused rows and columns after verifying that the space is not part of a template.
- Look for repeated custom styles created by copy-and-paste from external workbooks. Keep the styles the workbook actually uses and replace accidental duplicates carefully.
- Review conditional-formatting rules for oversized “Applies to” ranges and duplicate rules. Narrow them to the rows that can contain data.
- Use Home > Clear > Clear Formats only on cells where formatting is not required; clearing formats can change dates, percentages, borders and input cues.
Hidden rows and columns are not automatically harmless. They may contain old data, formulas or print-support ranges. Remove them only after checking dependencies, then save and measure the result.
Inspect shapes, charts, comments and SmartArt
Stacked or forgotten drawing objects can add substantial overhead even when they are not visible in the normal worksheet view. Check each sheet for hidden shapes, duplicate charts, comments or notes, SmartArt and text boxes.
- Open Home > Find & Select > Selection Pane to list objects and reveal hidden or overlapping items.
- Delete duplicate, obsolete or empty objects one at a time.
- Review charts for unused series and charts copied into hidden sheets.
- Open the comments or notes pane and remove items that are no longer part of the review record.
- Save and compare the file size after each category.
Do not delete a shape merely because it is hidden; buttons, checkboxes and macro controls may be intentionally invisible until a user takes an action. Confirm the object’s purpose first.
Rank #3
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.
Compress pictures without losing necessary detail
Pictures are often the fastest way to reduce a media-heavy workbook. Select any picture and choose Picture Format > Compress Pictures.
- Clear Apply only to this picture if all pictures should use the same compression settings.
- Select Delete cropped areas of pictures when the hidden portions will not be restored later.
- Choose a default resolution of 150 ppi or lower when that quality is sufficient for the workbook’s purpose.
- Confirm the dialog and save the copy.
Deleting cropped areas permanently removes the hidden image data. Discarding editing data prevents restoration of the original edit state, so retain the untouched backup if anyone may need to recrop or revert an image. For a workbook intended only for on-screen review, a lower resolution is usually more appropriate than preserving print-quality originals; for a workbook used to produce high-resolution print output, test representative pages before accepting the reduction.
Also inspect pictures that are hidden behind other pictures or placed on hidden sheets. Compression applies to the image object, not just to what is currently visible on screen. After compression, check logos, screenshots, small labels and chart images at their normal viewing size.
Reduce PivotTable storage and refresh overhead
PivotTables can store a copy of source data in a cache. If the source remains available and the workbook can refresh when opened, you may be able to remove that stored copy.
- Click inside the PivotTable and open PivotTable Analyze > Options (the exact tab label can vary by Excel version).
- On the Data tab, clear Save source data with file.
- Enable Refresh data when opening the file if the source is reliably available and refresh-on-open is acceptable for recipients.
- Save, close and reopen the workbook while connected to the source.
- Confirm that every PivotTable refreshes, filters correctly and displays the expected totals.
This approach is unsuitable when recipients must open the file offline, when the source is not accessible to them, or when a fixed snapshot is required. In those cases, retaining source data may be more important than reducing the file size.
Recommended Free Tools
Rank #4
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- Up to 2 TB Shared Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Share Your Family Subscription | You can share all of your subscription benefits with up to 6 people for use across all their devices.
Optimize Power Query and Power Pivot models
Data models can be larger than the visible worksheets because they store imported columns, relationships and calculated structures. In Power Query, remove columns and rows that are not used downstream as early as practical in the query. Every unnecessary field carried into the model increases storage and can increase refresh work.
Remove unnecessary model columns
- Keep only columns required for relationships, measures, filters, grouping and displayed results.
- Drop temporary import fields after they have served their transformation step.
- Use an appropriate data type; a field stored at a needlessly precise type can consume more model memory than a correctly typed field.
- Prefer a calculated measure where the result can be calculated at query time instead of storing a repeated calculated column for every row.
Measures and calculated columns are not interchangeable: a measure is evaluated in filter context, while a calculated column stores a value per row. Choose the one that preserves the required behavior, then test totals and filters.
Use Workbook Size Optimizer when available
Microsoft documents a Workbook Size Optimizer for applicable Power Query or Power Pivot workbooks. If the command is available in your Excel build, review its recommendations rather than accepting every change automatically. Record which tables, columns or model structures are removed, then refresh and validate all dependent PivotTables, formulas and reports.
Choose between .xlsx and .xlsb
Saving a copy as an Excel Binary Workbook (.xlsb) can make a workbook smaller and may improve opening and saving speed. Microsoft describes the binary format as usually smaller, but the actual compression depends on workbook contents.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minute| Option | Expected size effect | Functional risk | Compatibility | Best fit |
|---|---|---|---|---|
Keep .xlsx |
Content-dependent; no format conversion benefit | Lowest format-conversion risk | XML-based open standard; generally preferable when third-party interoperability matters | Files exchanged with varied tools or systems |
Save a copy as .xlsb |
Usually smaller according to Microsoft, but no guaranteed percentage | Requires testing of macros, links, queries, pivots and recipient workflows | Some third-party tools and services may not support binary workbooks | Large workbooks used mainly in desktop Excel |
Use File > Save As, choose Excel Binary Workbook (*.xlsb), and work from the new copy. Do not delete the .xlsx original until the binary version has been opened by the people and systems that will use it. A smaller file is not automatically a better exchange format if a recipient’s importer expects XML.
Best Value
![OfficeSuite Home & Business 5 in 1 Office Pack Documents, Sheets, Slides, PDF, Mail & Calendar Lifetime License 1 Windows PC 1 User [PC Online code]](https://m.media-amazon.com/images/I/41gPqMH6KFL._SL160_.jpg)
- Create, edit and style DOCUMENTS, SPREADSHEETS & PRESENTATIONS – all the features that you need to get work done
- Included PDF functions to FILL & SIGN forms, ANNOTATE and password PROTECT your PDF documents
- Compatibility with the most popular file formats - OPEN, EDIT & CREATE new and existing documents
- Manage all your email accounts and efficiently schedule with the inlcuded MAIL & CALENDAR apps
- Lifetime License for 1 Windows PC or Laptop
Match the workbook to service limits
Cloud services impose feature-specific limits that are different from the maximum size of a local Excel installation. Microsoft documents these figures for the stated services and scenarios:
| Service or scenario | Documented figure | What it means |
|---|---|---|
| Upload an Excel workbook to Power BI | 1 GB | Microsoft’s stated maximum for uploading an Excel workbook to Power BI; it is not a universal Excel file limit. |
| View core worksheet contents in Excel for the web through OneDrive for work or school | 30 MB | Microsoft’s stated ceiling for the core worksheet contents in this web-view scenario. |
| SharePoint Online and Excel Web App in memory-efficient data-model guidance | 10 MB | Microsoft’s documented limit for that guidance and feature context, not a limit for every local workbook. |
If a workbook must fit one of these services, target the relevant documented limit and test the actual upload, web opening and refresh behavior. A file that opens locally can still exceed a service’s memory or feature allowance.
Verify the reduced workbook before replacing the original
Cleanup is complete only after the reduced copy behaves like the original for the tasks that matter. Use a repeatable acceptance check:
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →- Close Excel completely, reopen the reduced copy and confirm that it opens without repair warnings.
- Force a full recalculation with Formulas > Calculate Now, then inspect key totals and error cells.
- Refresh every Power Query connection, PivotTable and Power Pivot model that should remain refreshable.
- Check external links and confirm that prompts, update paths and expected values still work.
- Run the workbook’s macros from a trusted copy and verify buttons, forms and event procedures.
- Inspect print areas, page breaks, headers, footers and exported PDFs; trimming the used range can alter printing.
- Review charts, slicers, images, comments, hidden sheets and protected ranges.
- Open the file on the recipient’s target platform, including Excel for the web or SharePoint when applicable.
- Compare the final file size with the baseline and record which changes produced it.
If a feature is broken, return to the backup and reapply changes in smaller groups. Restore the last category that caused the failure, then test the remaining categories separately. Never use a reduced copy as the only surviving version of a workbook that contains business records or irreplaceable source data.
Choose the method by cause, not by habit
| Likely cause | First action | Visible or functional change risk | External data requirement | Main effect |
|---|---|---|---|---|
| Unused formatted cells or an expanded used range | Review > Check Performance; then delete excess rows and columns after inspection | Can remove intentional template formatting or Pixel Art | None, unless deleted cells are referenced | File size and often editing performance |
| Pictures and cropped image data | Picture Format > Compress Pictures; consider 150 ppi or lower | Lower resolution; cropped data and editing history may be unrecoverable | None | File size, with possible image-quality change |
| Duplicate styles, shapes, charts or comments | Inspect styles and the Selection Pane; remove confirmed duplicates | Can alter appearance, controls or review history | None | File size and sometimes opening speed |
| PivotTable cache | Clear Save source data with file; enable Refresh data when opening the file | Offline users may lose the ability to view or refresh the cache | Source must be reachable at open | File size; refresh behavior changes |
| Power Query or Power Pivot model | Remove unused columns and use Workbook Size Optimizer where available | Measures, relationships or reports can break if dependencies are removed | Refresh connections must remain valid | Model size and refresh performance |
| Large desktop workbook with compatible recipients | Save a tested copy as .xlsb |
Some tools may not read binary workbooks | Depends on recipient and integrations | Usually smaller file and potentially faster open/save |
Common mistakes to avoid
- Clearing values instead of deleting cells: the empty formatted area can remain in the used range.
- Optimizing every sheet without inspection: intentional blank formatting and Pixel Art may be removed.
- Deleting PivotTable source data first: the table may still be required for refresh or cache reconstruction.
- Compressing only the visible picture: hidden images on other sheets can still account for most of the file size.
- Assuming
.xlsbalways wins: Microsoft notes that compression depends on content, and compatibility may be more important. - Replacing the original immediately: a broken macro, link, print area or refresh path may not be noticed until later.
- Expecting a fixed percentage reduction: the result depends on whether the cause is images, styles, used-range expansion, PivotTable caches or a data model.
The practical sequence is therefore diagnostic: measure, isolate, remove the confirmed source of bloat, save, reopen and validate. That approach reduces the file while preserving formulas and the features your recipients actually use.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
