• 欢迎访问速搜资源吧,如果在网站上找不到你需要的资源,可以在留言板上留言,管理员会尽量满足你!

【速搜问答】Excel文件大小如何减小

问答 admin 9个月前 (03-13) 166次浏览 已收录 0个评论

汉英对照:
Chinese-English Translation:

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

With the increasing content of Excel file and editing, the file will become larger and larger. In addition to text, a workbook also has various charts and color pictures, which take up a lot of space. Too large a file will not only affect the speed of sending mail, but also take up a lot of hard disk space. Fortunately, you only need to do a few simple operations, you can reduce the size of the excel file.

尝试几种简单的方法

Try several simple methods

1、查看未使用单元格的格式。一直将鼠标拖动到每个工作簿的最底部,选中所有空行,删除所有未使用的单元格。这样能很大程度地缩减文件大小。

1. View the format of unused cells. Drag the mouse all the way to the bottom of each workbook, select all empty rows, and delete all unused cells. This greatly reduces the file size.

2、将文件保存为后缀名为.xlsb 的二进制格式。 这样可以把工作簿变成包含多个二进制文件的压缩文件夹。具体压缩多少取决于工作表的内容。但是,要打开、关闭、保存这样的文件,所费的时间往往比常用文件格式(.xls)要长一些。

2. Save the file in binary format with the suffix. Xlsb. This turns the workbook into a compressed folder containing multiple binaries. How much compression depends on the contents of the worksheet. However, to open, close and save such a file, it often takes longer than the common file format (. XLS).

当你将文件另存为.xlsb 格式后,选中并删除数据范围外的所有单元格,通常是数据的右侧和下方。

When you save the file as. Xlsb format, select and delete all cells outside the data range, usually the right and bottom of the data.

选中同样的单元格,删除单元格所有的格式,像是颜色、线条等等。删除工作簿里每个工作表的格式。

Select the same cell and delete all cell formats, such as colors, lines, etc. Delete the format of each sheet in the workbook.

再次将工作簿保存为“.xlsx” 格式。然后查看一下这些操作缩减了多少文件体积。

Save the workbook in “. Xlsx” format again. Then look at how much file size these operations have reduced.

3、将工作簿保存为相同的文件和格式,但是使用另一个文件名。这种转换过程或许可以消除文件里的多余空间和无效数据。

3. Save the workbook to the same file and format, but with a different file name. This conversion process may eliminate redundant space and invalid data in the file.

包含图标和格式的工作簿

Workbooks with icons and formats

1、打开 Excel 文件。

1. Open the excel file.

2、将 Excel 文件保存为 “.html” 格式。

2. Save the excel file in “. HTML” format.

3、更改 .html 文档的文件名称。 然后将新文档保存为“.xls” 格式。

3. Change the file name of the. HTML document. Then save the new document in “. XLS” format.

仅包含文本的工作簿

Text only workbooks

1、打开 Excel 文件。

1. Open the excel file.

2、将 Excel 文件保存为 “.xml”格式。

2. Save the excel file in “. XML” format.

3、重命名“.xml”文件,然后重新保存为“.xls”文件,并命名新的名字。

3. Rename the “. XML” file, then resave it as the “. XLS” file, and name it with a new name.

使用“WinZip”程序

Using “winzip” program

1、打开文档,找到你想要压缩的文件。点击文件名,将后缀名“.xls”更改为“.zip”。

1. Open the document and find the file you want to compress. Click the file name and change the suffix “. XLS” to “. Zip”.

2、点击文件,选择“用 WinZip 打开”。然后选择一个路径来保存解压后的内容。

2. Click on the file and select “open with winzip”. Then choose a path to save the extracted content.

3、使用“WinZip”程序重新压缩内容。

3. Use the “winzip” program to recompress the content.

4、打开文档。选中文件,将“.zip”后缀更改为“.xlsx”。你应该会注意到文件体积减了不少。

4. Open the document. Select the file and change the “. Zip” suffix to “. Xlsx”. You should notice that the size of the file has decreased a lot.

5、你也可以前往工作簿子文件夹,找到体积最大的工作簿。重新打开原始的 excel 文件,创建几个新的电子表格。返回到体积较大的工作簿中,选中包含数据的单元格,将它们复制粘贴到新工作表中。然后,删除体积过大的电子表格,保存文件。

5. You can also go to the workbooks subfolder and find the largest workbooks. Re open the original excel file and create several new spreadsheets. Return to the larger workbook, select the cells that contain the data, and copy and paste them into the new worksheet. Then, delete the oversized spreadsheet and save the file.

找到并处理错误源

Find and process the source of the error

1、找到导致 Excel 文件体积过大的工作表之后,将文件另存为.xls 格式,这样可以方便你查找工作表和存在的问题。同时,数据也可以从原文件中独立出来。

1. After finding the worksheet that causes the volume of Excel file to be too large, save the file as. XLS format, so that you can easily find the worksheet and the existing problems. At the same time, the data can be separated from the original file.

2、复制 Excel 文件,方便之后操作,然后删除里面有问题的列,并保存文件。

2. Copy the excel file to facilitate later operation, and then delete the problematic columns and save the file.

3、如果你比较两个文件的体积,会发现删掉存在问题的列之后,Excel 文件的体积会缩减几 KB 到几 MB 不等。

3. If you compare the volume of two files, you will find that after deleting the problematic column, the volume of Excel file will be reduced by several KB to several MB.

另存为

Save as

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

This method is suitable for spreadsheets with pictures.

1、点击“文件”,然后选择“另存为”。

1. Click “file” and select “save as”.

2、在“保存”按钮的旁边,你会看到工具下拉菜单。点击它。

2. Next to the Save button, you will see the tools drop-down menu. Click on it.

3、压缩图片。

3. Compress the picture.

4、压缩到“屏幕”或“打印”大小。

4. Compress to screen or print size.

5、保存文件。完成。

5. Save the file. Done.

小提示

Tips

如果你想在 Mac 电脑上压缩 Excel 文件,可以使用第三方软件,如“FILEminimizer Office” 或“Express Zip Mac” 压缩软件。

If you want to compress Excel files on a Mac, you can use third-party software, such as “fileminimizer office” or “express zip Mac”.

如果你将 Mac 电脑上的 Excel 文件以邮件形式发送到 Windows 电脑,确保将文件保存为“.xlsx”格式。这样 Windows 电脑在打开文件时不会遇到任何问题,打开的文件也不会出现任何诡异的格式。

If you email Excel files from your Mac to your Windows computer, make sure you save them in “. Xlsx” format. In this way, windows computer will not encounter any problems when opening the file, and the open file will not appear any strange format.

在尝试压缩文件前,请先将原文件备份好。在压缩文件的过程中,你可能会丢失一些原工作簿的格式、图标或其它重要内容。

Please back up the original file before trying to compress it. In the process of compressing files, you may lose some formats, icons or other important contents of the original workbooks.

如果你的 Excel 文件带有宏,将它保存为 HTML 格式或 XML 格式会移除相关编码和信息。这时,你需要手动浏览每个工作表,然后删除未使用单元格的格式。

If you have an excel file with a macro, saving it in HTML or XML will remove the encoding and information. At this point, you need to manually browse through each sheet, and then delete the unused cell format.


速搜资源网 , 版权所有丨如未注明 , 均为原创丨转载请注明原文链接:【速搜问答】Excel文件大小如何减小
喜欢 (0)
[361009623@qq.com]
分享 (0)
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址