How to reduce Excel file size?

How to reduce file size in Excel by deleting worksheets

Using multiple worksheets in Excel makes it easier to build a spreadsheet, but the more worksheets you use, the larger the file size. Deleting unnecessary worksheets can help reduce file size.

To delete a worksheet in Excel:

1. Make sure that the worksheet you want to delete does not contain any data that is needed or referenced by other worksheets.
2. Right-click on the worksheet tab at the bottom of the screen.
   
3. Selectto delete.
   

This worksheet will be deleted - repeat these steps for any other worksheets you want to delete.

Clear PivotTable Cache

PivotTables in Excel are a great way to analyze your data, but they can have a significant impact on the size of your Excel file. This is because, by default, Excel saves a cache of your PivotTable source data with your file. However, you can change this setting and refresh the data cache when the spreadsheet is opened.

To stop saving the PivotTable cache in Excel:

1. Select any cell of the PivotTable report.
2. Open thePivotTable Analysismenu.
   
3. Selectoption.
   
4. Select theDatatab.
   
5. Make sure"Use a file to save source data" is unchecked.
   
6. Click "OK" to confirm.

Save formulas as values

Excel formulas allow you to do almost anything you want to do in Excel using built-in functions. However, formulas take up more space than values, so if you have a spreadsheet with a lot of calculated formulas, you may want to consider converting those formulas to values.

To save a formula as a value in Excel:

1. Select the formula that contains your formula.
2. Use the keyboard shortcutCtrl C on Windows orCmd Con Mac to copy a cell. Alternatively, you can right-click it and selectCopy.
   
3. Right-click the cell and selectPaste Special>Value.
   

Your formula will be replaced with the value of its result.

Delete or compress pictures

Pictures are not something commonly used in Excel spreadsheets, but if you use some in your document, then those pictures can increase your file size. You can delete these pictures or compress them.

Compress pictures in Excel:

1. Select pictures in a spreadsheet.
2. Picture Formattab will appear in the ribbon - select this menu.
   
3. Press theCompress Pictureicon.
   
4. Select a resolution - the lower the resolution, the smaller your Excel file will be.
   
5. Make sureRemove cropped area of image is checked.
   
6. If you want to apply the same compression to all pictures, make sure the "Apply to this picture only" checkbox is unchecked.
   
7. ClickOKto compress your image.

Reduce Excel file size by saving in XLSB format

Another way to reduce the size of an Excel file is to save it in binary format. The default format is XML, which is more suitable for other applications, but if you only plan to use the file in Excel, saving it as an .XLSB file can help reduce file size.

Save Excel file in .XLSB format:

1. PressFile > Save As.
2. Choose a location to save your file.
3. From the file format list, selectExcel Binary Workbook.
   
4. PressSaveConfirm.

Solving Excel Problems

If you're wondering how to reduce Excel file size, you can usually solve the problem by following the steps above.

Excel is a powerful application, but when something goes wrong, it can be frustrating to fix. If you're having trouble, you may want to try preventing Excel from crashing.

The above is the detailed content of How to reduce Excel file size?. For more information, please follow other related articles on the PHP Chinese website!