如何减小Excel文件的大小

下载PDF文件
共同创作者是 wikiHow员工

下载PDF文件

随着Excel文件内容不断增加和进行编辑，文件会变得越来越大。一个工作簿除了文字，还会有各种图表和彩色图片，这些都会占用大量空间。文件过大不仅会影响邮件发送的速度，还会占用许多硬盘空间。好在你只需要进行几个简单操作，就可以缩减Excel文件的大小。

方法 1
方法 1 的 6:

尝试几种简单的方法

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/dc\/Reduce-Size-of-Excel-Files-Step-1-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-1-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dc\/Reduce-Size-of-Excel-Files-Step-1-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-1-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    一直将鼠标拖动到每个工作簿的最底部，选中所有空行，删除所有未使用的单元格。这样能很大程度地缩减文件大小。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3b\/Reduce-Size-of-Excel-Files-Step-2-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-2-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Reduce-Size-of-Excel-Files-Step-2-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-2-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    这样可以把工作簿变成包含多个二进制文件的压缩文件夹。具体压缩多少取决于工作表的内容。但是，要打开、关闭、保存这样的文件，所费的时间往往比常用文件格式（.xls）要长一些。 [1]
    • 当你将文件另存为.xlsb格式后，选中并删除数据范围外的所有单元格，通常是数据的右侧和下方。
    • 选中同样的单元格，删除单元格所有的格式，像是颜色、线条等等。删除工作簿里每个工作表的格式。
    • 再次将工作簿保存为“.xlsx” 格式。然后查看一下这些操作缩减了多少文件体积。
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d7\/Reduce-Size-of-Excel-Files-Step-3-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-3-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d7\/Reduce-Size-of-Excel-Files-Step-3-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-3-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    这种转换过程或许可以消除文件里的多余空间和无效数据。
    广告
方法 2
方法 2 的 6:

包含图标和格式的工作簿

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/57\/Reduce-Size-of-Excel-Files-Step-4-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-4-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/57\/Reduce-Size-of-Excel-Files-Step-4-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-4-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f8\/Reduce-Size-of-Excel-Files-Step-5-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-5-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f8\/Reduce-Size-of-Excel-Files-Step-5-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-5-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9d\/Reduce-Size-of-Excel-Files-Step-6-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-6-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Reduce-Size-of-Excel-Files-Step-6-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-6-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    然后将新文档保存为“.xls” 格式。
    广告
方法 3
方法 3 的 6:

仅包含文本的工作簿

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f9\/Reduce-Size-of-Excel-Files-Step-7-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-7-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Reduce-Size-of-Excel-Files-Step-7-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-7-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/15\/Reduce-Size-of-Excel-Files-Step-8-Version-6.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-8-Version-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/15\/Reduce-Size-of-Excel-Files-Step-8-Version-6.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-8-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7e\/Reduce-Size-of-Excel-Files-Step-9-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-9-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7e\/Reduce-Size-of-Excel-Files-Step-9-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-9-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    广告
方法 4
方法 4 的 6:

使用“WinZip”程序

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1e\/Reduce-Size-of-Excel-Files-Step-10-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-10-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Reduce-Size-of-Excel-Files-Step-10-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-10-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    点击文件名，将后缀名“.xls”更改为“.zip”。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3d\/Reduce-Size-of-Excel-Files-Step-11-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-11-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Reduce-Size-of-Excel-Files-Step-11-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-11-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    然后选择一个路径来保存解压后的内容。
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e3\/Reduce-Size-of-Excel-Files-Step-12-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-12-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Reduce-Size-of-Excel-Files-Step-12-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-12-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/95\/Reduce-Size-of-Excel-Files-Step-13-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-13-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/95\/Reduce-Size-of-Excel-Files-Step-13-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-13-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    选中文件，将“.zip”后缀更改为“.xlsx”。你应该会注意到文件体积减了不少。 [2]
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c4\/Reduce-Size-of-Excel-Files-Step-14-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-14-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Reduce-Size-of-Excel-Files-Step-14-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-14-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    重新打开原始的excel文件，创建几个新的电子表格。返回到体积较大的工作簿中，选中包含数据的单元格，将它们复制粘贴到新工作表中。然后，删除体积过大的电子表格，保存文件。
    广告
方法 5
方法 5 的 6:

找到并处理错误源

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/91\/Reduce-Size-of-Excel-Files-Step-15-Version-5.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-15-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Reduce-Size-of-Excel-Files-Step-15-Version-5.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-15-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    找到导致Excel文件体积过大的工作表之后，将文件另存为.xls格式，这样可以方便你查找工作表和存在的问题。 同时，数据也可以从原文件中独立出来。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f0\/Reduce-Size-of-Excel-Files-Step-16-Version-2.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f0\/Reduce-Size-of-Excel-Files-Step-16-Version-2.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1c\/Reduce-Size-of-Excel-Files-Step-17-Version-2.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1c\/Reduce-Size-of-Excel-Files-Step-17-Version-2.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    如果你比较两个文件的体积，会发现删掉存在问题的列之后，Excel文件的体积会缩减几KB到几MB不等。
    广告
方法 6
方法 6 的 6:

另存为

下载PDF文件

这个方法适用于带有图片的电子表格。

  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6e\/Reduce-Size-of-Excel-Files-Step-18-Version-2.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Reduce-Size-of-Excel-Files-Step-18-Version-2.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Reduce-Size-of-Excel-Files-Step-19-Version-2.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Reduce-Size-of-Excel-Files-Step-19-Version-2.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    点击它。
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Reduce-Size-of-Excel-Files-Step-20-Version-2.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Reduce-Size-of-Excel-Files-Step-20-Version-2.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Reduce-Size-of-Excel-Files-Step-21-Version-2.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Reduce-Size-of-Excel-Files-Step-21-Version-2.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cf\/Reduce-Size-of-Excel-Files-Step-22.jpg\/v4-460px-Reduce-Size-of-Excel-Files-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cf\/Reduce-Size-of-Excel-Files-Step-22.jpg\/v4-728px-Reduce-Size-of-Excel-Files-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    完成。
    广告

小提示

  • 如果你想在Mac电脑上压缩Excel文件，可以使用第三方软件，如“FILEminimizer Office” 或“Express Zip Mac” 压缩软件。
  • 如果你将Mac电脑上的Excel文件以邮件形式发送到Windows电脑，确保将文件保存为“.xlsx”格式。这样Windows电脑在打开文件时不会遇到任何问题，打开的文件也不会出现任何诡异的格式。 [3]
广告

警告

  • 在尝试压缩文件前，请先将原文件备份好。在压缩文件的过程中，你可能会丢失一些原工作簿的格式、图标或其它重要内容。
  • 如果你的Excel文件带有宏，将它保存为HTML 格式或XML 格式会移除相关编码和信息。这时，你需要手动浏览每个工作表，然后删除未使用单元格的格式。
广告

你可能还喜欢

如何
向Illustrator中添加字体
如何
登录Twitter
如何
下载YouTube视频
如何
从网站上免费下载视频
如何
保存Instagram上的图片
如何
更改YouTube语言设置
查看Instagram而不注册账号
如何
使用VPN
如何
从SIM卡中获取你的手机号码
如何
打开EPUB文件
如何
绕过YouTube的年龄限制
如何
关闭YouTube限制模式
如何恢复被冻结的Twitter账号
如何知道自己是否被Discord上的好友拉黑了
广告

参考

  1. ↑ http://msdn.microsoft.com/en-us/library/aa730921.aspx# office2007excelperf_WorkbookOpeningClosingSavingSize
  2. ↑ http://datapigtechnologies.com/blog/index.php/how-to-compress-xlsx-files-to-the-smallest-possible-size/
  3. ↑ http://www.michaelhanscom.com/eclecticism/2010/01/26/microsoft-excel-xls-and-xlsx-weirdness/

关于本wikiHow

其他语言
本页面已经被访问过108,546次。

这篇文章对你有帮助吗？

广告