• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Reduce File Size in Excel

September 13, 2021 by Andrew Childress
Reduce Excel file size

When working with Excel chances are you’ll want to share files. Sometimes, advanced workbooks become very large. Here's how to reduce file size in Excel.

When you work with Excel spreadsheets, chances are you’ll want to share them with other people. But sometimes, advanced workbooks become very large and occupy a significant amount of file storage space on your computer. Plus, some file sharing services and email providers limit the size of attachments that you can send. Fortunately, Excel offers an easy fix. Let’s learn how to reduce file size in Microsoft Excel.

How to Reduce File Size in Excel

Excel spreadsheets default to a certain file format: .xlsx. This is by far the most commonly used format for Excel sheets, but it isn’t your only option. Plus, if you need to keep file size to an absolute minimum, it won’t be your best bet. Excel offers a different format: Excel Binary Workbooks, which are abbreviated .xlsb. 

By saving your spreadsheets in .xlsb format, you’ll save precious storage space. But these formats still maintain most functionality, so for everyday use .xlsb is a workable option to use over and over again.

Saving in this format is very easy. To get started, find the File dropdown menu. This sits in the far upper left corner of your Excel window. Click on it to open it up. You’ll see an array of options appear. The one you’ll want is Save As.

Reduce Excel file size

When you click Save As, Excel will automatically launch the Save As dialog box. At the top, you can give your file a name. In the Where section, you can specify exactly where you want your images to be saved on your computer or network drive.

Reduce file size in Excel

Finally, to reduce file size in Excel, click on the File Format dropdown. Under Speciality Formats, you’ll see what you’re looking for: Excel Binary Workbook (.xlsb). Click there, and then choose Save.

How to reduce Excel file size

Excel will save your finished spreadsheet file in the new, reduced-size file format. Now, you’ll find that it’s easier to share with audiences anywhere.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Date in ExcelDATE in Excel
Next Post:SUMPRODUCT in ExcelSumproduct Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top