The Excel binary file uses noticeably less space while saving than (.xlsb) format, one thing you should keep in mind that, like everything, saving an Excel workbook in binary format brings some pros and cons. So, the file size is reduced on a large scale. xlsb) file contains 1,666 KB where the (. xlsx) format whether it is reduced or not. Here, we will check the file size of the (.Now, the two files are saved in the same directory.xlsb) format in the same folder in which you have saved the previous (. First of all, save your sample Excel file in (.This is the easiest and most efficient way of reducing your file size. xlsb) reduces the size of your file by around 40%. Just applying some techniques will let you reduce the file size. Sometimes, you don’t need to delete the file data or formatting to reduce the size of an Excel file. Read More: How to Compress Excel File for Email (13 Quick Methods)Ģ. If you don’t need them just delete them all. All you can do is unhide the rows and columns of the Excel worksheet and see if you need them or not. Suddenly you realize that your file contains some hidden elements which you don’t require. You may accidentally hide some rows or columns of the Excel worksheet you are working on. Sometimes unnecessary hidden cells are the reason for larger Excel files. Check and Delete Unnecessary Hidden Cells

Read More: How to Reduce Excel File Size Without Deleting Data (9 Quick Tips)ġ.2. After this clear the blank cells as we did earlier. This will automatically find the blank areas of your Excel workbook. On that box tick on the Blanks and press OK. It will open up Go To Special dialog box.On the Home tab, Press Find & Select and then press Go To Special.

After selecting the blank cells, In the Home tab on the Clear option press Clear all.

The arrow signs indicate where you want to put your command.

If you want to select the entire blank cells just click CTRL+Shift+ ↓+ → together.

Removing the formatting from these blank cells reduces your file size. Sometimes you accidentally do some formatting in these unused cells which actually increases your file size. Deleting/Clearing Blank Cells in ExcelĪfter you complete a task in the Excel workbook, there are so many unused cells that have no usefulness in your workbook. There are several cases in which you have no other option than to delete the data or format. In this section, we will discuss 3 proven methods to reduce/compress large Excel file size. Related Articles 3 Top Methods to Reduce/Compress Large Excel File Size

Rar file size reducer