To delete/clear the unused rows below the last used row and unused columns to the right of the last used column, select the unused rows and columns.This would now reduce the file size of the Excel workbook after saving it.Įxample #5 – Deleting / Clearing Unused Cell RangesĪnother way that can help reduce the size of an Excel workbook is to delete the unused portions below and on the right of the data.Now click on ‘Clear Formats’ on expanding the dropdown.Click on the ‘Home’ tab and then expand the ‘Clear’ dropdown in the ‘Editing’ section as below.Select the data from which we wish to remove the data formatting:.To do this, we will follow the below steps: Let’s say we wish to remove the formatting applied to a worksheet, say to Sheet6 named as ‘Example4’ in a workbook. So we can look for formatting that we can avoid and then select that data and remove it from the workbook. This would now create a zipped file for the same and thus we will observe a reduction in file size (138 KB):Įxample #4 – Removing Unused or Unnecessary Data FormattingĪnother reason for the increase in Excel file size is the data formatting applied to it, like cell color, font style, background color, borders, etc.After saving the file, right-click on the file folder and move or hover the cursor to ‘Send To’ option and then click on ‘Compressed (zipped) folder’.Let’s say we have an Excel file whose size we see is 1137 KB.
#EXCEL FILE SIZE REDUCER ONLINE ZIP#
Following steps can be used to zip the file: This would reduce the size to 10-15% approximately. On doing this, the Excel file size will be reduced.Īnother way to reduce the size of an Excel file is to zip the file.Now click on ‘Email (96 ppi)’ and select the first two options in the ‘Compression options’ section in case there is more than one image/picture (and we wish to compress each) and also when we wish to delete the cropped areas of image/picture as well.On doing this, a new pop-up window will appear as below:.Click the image in the worksheet and then activate the ‘Format’ ribbon as follows.Now if we wish to reduce the file size by compressing the image size, we follow the below steps: Let us say we have an Excel file with an image in a worksheet. Example #2 – Compressing the Size of ImagesĮxcel workbooks are sometimes large in size due to some pictures within it.
0 kommentar(er)
