Excel is a great support tool, making the working process much more convenient and smooth. However, sometimes the size of Excel files is too large, it will take time for you to wait for the file to finish loading. It is a nuisance that many people encounter. Then yes How to reduce the size of Excel files? Are not? Read the article below to learn how to do it simply and effectively.

How to reduce Excel file size with a simple but effective operation?

Remove conditional formatting

Conditional formatting is one of the most useful functions in the work process. It has the effect of highlighting specific data and making it easier to find when you need it. However, this function is one of the reasons that can significantly weigh down your Excel file. If you want to reduce the Excel file size, you can remove this format from the worksheet.

The specific way is as follows:

• Select formatted cells on the sheet.

• Click the following links: Select Home > select Conditional Formatting > Select Clear Rules > Select Clear 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, your Excel file size has decreased significantly.

Eliminate unnecessary formulas in spreadsheets

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

Proceed as follows:

• Select the cells you calculated. Or you can also press Ctrl + A to select the entire cell in the sheet.

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

It also removes hyperlinks which can increase the size of the Excel file.

Eliminate unnecessary formulas in spreadsheets

Clear data format

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

Here’s how:

• Select all cells, columns, rows which are formatted data. You must be careful to select cells that do not contain data.

• Click to select Home > select Edit > select Clear Formats.

Clearing data formatting is a way to help reduce the size of Excel files

Compress images in Excel

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

The specific way is as follows:

• Click on the image you want to compress.

• Select the Image Format tab from the toolbar.

• Chọn Compress Photos.

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

• Resolution: Choose the resolution of the image you want (you must prioritize email).

Compressing image sizes in Excel makes Excel files smaller

The above article has guided you How to reduce the size of Excel files?. I hope the article provided useful information to help you use Excel more effectively. If this article was helpful to you, don’t forget to share it so everyone knows.