Excel is a great support tool, helping the work process go much more smoothly. However, sometimes the size of Excel files is too large, making you waste time waiting for the file to finish loading. This is a problem that many people encounter. Then yes How to reduce Excel file size Are not? Please read the article below to learn how to do it simply and effectively.

How to reduce the size of an Excel file with simple but effective operations?

Remove Conditional Formatting

Conditional formatting is one of the very useful functions in the work process. It helps highlight specific data and makes it easy to find when you need it. However, this function is one of the reasons that can make your Excel file heavier. If you want to reduce the size of your Excel file, you can remove this format from the spreadsheet.

The specific way to do this is as follows:

• Select the formatted cells on the sheet.

• Click the following links: Select Home > select Conditional Formatting > Select Clear Rules > Select Clear in Selected Cells.

Remove conditional formatting in Excel

If you want to remove conditional formatting from all cells on the sheet, select Clear rules from another sheet. At this point, the size of your Excel file has been significantly reduced.

Remove unnecessary formulas from the spreadsheet

In Excel, formulas allow you to better combine data. However, at the end of the calculation process, people often forget to remove unnecessary formulas. Eliminating these formulas is also a way to reduce Excel file size.

Do the following:

• Select the cells you calculated. Or you can also press Ctrl + A to select all cells on the sheet.

• Select Copy and Paste Special, click the Values ​​box.

This method also allows you to remove hyperlinks that can increase the size of the Excel file.

Remove unnecessary formulas from the spreadsheet

Delete data format

Data formatting helps structure information more precisely in Excel. However, this can also be the cause of heavier Excel file size. You can remove these formats to reduce the size of the Excel file.

Here’s how:

• Select all formatted cells, columns and rows. You should be careful about selecting cells that do not contain data.

• Click Home > select Edit > select Clear Formats.

Removing data formatting is one way to reduce Excel file size

Compress images in Excel

Excel is often used to calculate and present data. Normally people don’t use Excel to store images. However, in some cases you still need to use images in Excel. At this time, compressing images in Excel is also a way to help reduce file size.

The specific way to do this is as follows:

• Click on the image you want to compress.

• Select the Picture Format tab in the toolbar.

• How to compress images.

• Uncheck the first box to compress the size of all images in the Excel file.

• Resolution: choose the resolution of the image you want (you must favor the Email choice).

Compressing image size in Excel makes Excel files lighter

The article above gave you instructions How to reduce Excel file size. Hopefully this article has provided you with some useful information to help you use Excel more effectively. If this article is useful to you, don’t forget to share it so that everyone can know.